Numbering rows with filters

[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???

 

[T. Valko]

Try this...

Assume the filter applies to the range B210. B11 = 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.