00:00Imagine this. If you have a data set that looks something like that with rows merged together and
00:06your objective is to assign sequential number to each individual rows within the data set,
00:11you can't simply fill sequential number for a couple of rows and click and drag the fill
00:15handler in this manner. If you have this situation, you're going to have to use a
00:19really easy formula using count A function to resolve it. Select the column for sequential
00:24numbering, equal count A, A5 colon A5, make start range A5 an absolute reference and then press
00:30ctrl enter to apply the formula to the entire selection. This function counts the number of
00:35non-empty cells from the header in cell A5 and since we're using a fixed reference of $A, $5,
00:42that will create a dynamic range that expands as the formula is copied down to the lower rows.
00:48In other words, the number increases, hence creating a sequential number. With that being said,
00:53if we delete any rows like this, the integrity of the sequential number is still maintained.
Comments