Apr 04 2021 08:53 AM
I have a file with about 400 rows which I have set up to allow me to select using filters on any of the columns. I need to assign sequential numbers, starting with "1", to the selected rows. I can't figure out how to number ONLY the selected rows without human intervention.
In other words, if my filter selects the 40th through the 60th rows of my file, how can I number only those rows, starting with "1"?
Apr 04 2021 09:14 AM
Let's say that you want the sequence numbers in column A.
Select the visible (filtered) cells in column A.
In the following, I will assume that the first cell in the selection is A40.
Enter the formula
=MAX($A$1:$A39)+1
where 39 is the row number of the cell above the first cell in the selection.
Confirm the formula with Ctrl+Enter so that it is entered in all selected cells.
Apr 04 2021 09:25 AM
Apr 04 2021 10:46 AM
Apr 04 2021 01:39 PM