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.


olga wrote:
i created a cloumn (not filtered) to number each of my rows but when i filter
my rows my number column oes not stay numbered it filters along with the
others even thow its not filtered!?!


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