Numbering rows with filters
 

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

Numbering rows with filters
 

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.

--
Biff
Microsoft Excel MVP


"incbuilder" wrote in message
...
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???