Filters - Numbering Rows

  • Thread starter Thread starter twinkle17
  • Start date Start date
T

twinkle17

I want to number the rows of filtered cells, 1, 2, 3...

I can't fill series, or use the formula =a2+1...

Is there any way I can do this?

Cheers
 
Try somehting like this:

Put the row count outside of the filtered data. Assume the filtered range is
B2:C10.

Enter this formula in A2 and copy down to A10:

=SUBTOTAL(3,B$2:B2)

I'm assuming there are no empty cells in B2:B10.
 
Back
Top