Sequence function with a break in Excel - Your Questions Answered Series

Part two of Your Questions Answered Video Series. This time, we look at Alexander's question that he posted on the Sequence function in the Excel video. The question is very interesting as it calls for a break in the sequence but is still achieved with a single function. And I also wanted to share my solution as it uses all the modern Excel perks and shows how far Excel has come in recent years. Enjoy the video, and if you have ideas on how to optimize the solution, let me know in the comments. Links to blog posts and videos that are relevant: The Sequence Function in Excel (Excel Unplugged) - excelunplugged.com/2021/09/14/sequence-function-ad… Sequence function in Excel (YouTube) -    • Excel Sequence Function   Chapters: 0:00​ Intro 0:08 Alexander's question explained 1:55 A Vintage Excel Solution 4:20 Why a vintage solution is not perfect 5:02 solution with modern Excel 7:32 Optimized Solution with the LET and IFS functions 10:05 Further thinking on optimizations 12:05 Conclusion 12:17 Outro Gear Used: US Links Camera: Canon EOS R6 - amzn.to/3e9zxML Microphone: AKG C3000 (Analog Mic) - amzn.to/3tYd37w Audio converter: Zoom UAC-2 - amzn.to/3dgM8wS Laptop: Dell XPS 15 - amzn.to/3w8CyoK Lights: Elgato Key Light - amzn.to/3rurte7 EU Links Camera: Canon EOS R6 - amzn.to/3tubwGy Microphone: AKG C3000 (Analog Mic) - amzn.to/32pi2m0 Audio converter: Zoom UAC-2 - amzn.to/3amDRXP Laptop: Dell XPS 15 - amzn.to/3effMmT Lights: Elgato Key Light - amzn.to/3vcs6v9 Green Screen (visible in bloopers): amzn.to/3ajUm6Y Recorded With: Camtasia - www.techsmith.com/video-editor.html Subscribe for more Excel tutorials on the Excel Olympics YouTube Channel: bit.ly/EOYTsub Subscribe to the Excel Olympics Newsletter: bit.ly/3w3rkjK Disclaimer: Some links included in this description might be affiliate links. If you purchase a product or service with the links that I provide, I may receive a small commission with NO additional charge to you! I appreciate your support! #Excel #ExcelOlympics #gasperkamensek

• #
• #sequence_function_in_excel
• #sequence_with_a_break
• #sequence_function_with_a_break_in_excel
• #dynamic_arrays_in_excel
• #dynamic_array_functions_in_excel
• #sequence_function
• #new_excel_functions
• #excel_functions
• #excel_365
• #microsoft_excel
• #excel_sequence_function
• #excel_formulas
• #microsoft_365