I have filtered my Excel data and now I want to number the rows How do I do that

Question

Basically, all I want to do is add a new column to my data after filtering it according to a specific criterion, then add a series of integers to that column, one for each row. I.e., the information in one column looks like this:

Armstrong, John

Beattie, Jane

Coombs, John

And I want a new column running next to it so it looks like this:

1 Armstrong, John

2 Beattie, Jane

3 Coombs, John

I have tried inputting the first few numbers and then dragging them down to fill the rest of the column but when I do that all of the numbers turn to 1 for some reason.

Answer 1

1. Filter your data.
2. Select the cells you want to add the numbering to.
3. Press F5.
4. Select Special.
5. Choose "Visible Cells Only" and press OK.

6. Now in the top row of your filtered data (just below the header) enter the following code:

   =MAX($"Your Column Letter"$1:"Your Column Letter"$"The current row for the filter - 1") + 1
   
   Ex:
   
   =MAX($A$1:A26)+1

   Which would be applied to start at cell A27.

7. Hold Ctrl and press enter.