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?

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

You can use a formula to calculate the row number. For example, in
column A, enter the following:
=SUBTOTAL(3,$B$2:B2)

where column B contains no blank cells.
Copy the formula down to the last row of data.

Note: Don't use this formula in conjunction with the DataSubtotal
feature. When you choose to Remove Subtotals, it deletes the lines that
contain a Subtotal formula.


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?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html