Can you pick out a column that always has something in it--no matter how you
filter the data?

(If you can't, then add another column and put a 1 in each of those cells.)

Then I had the filter arrows in row 1 and my "special" column in column C.

This is what I put in B2
=SUBTOTAL(3,$C$2:C2)

And then I dragged it down.



heater wrote:

I have Autofilter on a spreadsheet and once I filter the data, I want that
data to be numbered in sequential order. I have numbered column A from 1 -
100, but after the filter, they are out of order (obviously). Is there a
fromula to put in column A that will automatically number the rows in
sequential order after the filter?

--

Dave Peterson