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