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