In this video, we show a method to create a sequence of numbers where the sequence has to be paused when it encounters a non-blank entry and continues afterwards. The trick, for me, lies in the SCAN Function
Workbook link:
docs.google.com/spreadsheets/...
00:00 Introduction
00:28 Problem description
00:51 My thought process
02:06 Why a SCAN function may work
02:32 SCAN function example
04:35 SCAN Solution starts
09:18 Solution 2 using SCAN
11:20 Closing thoughts
Негізгі бет Excel Challenge - Create sequential numbers with a twist (SCAN)
Пікірлер: 35