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

T. Valko

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:


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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question