How to use SEQUENCE function in Excel 365

preview_player
Показать описание
How to use SEQUENCE function in Excel 365 to generate numbers in a sequence. SEQUENCE function throws #SPILL error if return array didn't find blank cells. SEQUENCE function can be used with other functions (RANDBETWEEN, DATE, TRANSPOSE, RANDARRAY etc.) to customize sequence numbers.

File to Download:

0:00 About SEQUENCE Function
0:24 How to use SEQUENCE function
3:47 #SPILL! error in SEQUENCE function
4:22 SEQUENCE with TRANSPOSE function
5:04 SEQUENCE with RANDBETWEEN function
#ExcelSessions #Excel #MSExcel #MicrosoftExcel #ExcelSession
Рекомендации по теме
Комментарии
Автор

Learn in 5 minutes - How to use SEQUENCE function in Excel 365. Watch the video and share your feedback. Please comment if you need video on any Excel/ VBA topic

SessionsbySaurabh