Numbering rows with filters

  • Thread starter Thread starter incbuilder
  • Start date Start date
I

incbuilder

My first column is row numbers. When I apply a filter to my spreadsheet the
filter hides rows which in effect changes my row numbers. My first row is now
row 37. Is there a formula that I can use to dynamically generate row numbers
so that my row numbers will automatically adjust after the filter hids rows?
I have tried formulas with relative references, R[-1] , but this method
seems to still reference the hidden rows???
 
Try this...

Assume the filter applies to the range B2:D10. B1:D1 = column headers

Enter this formula in A2 and copy down to A10:

=SUBTOTAL(3,B$2:B2)

Make sure that A2:A10 (or whatever location you use for the row numbers) is
not *included* in the filtered range.
 
Back
Top