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.

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.

Haldun Alay wrote:
i have a table which contains names and depended informations. on first
column i'm numbering the rows but when i use the autofilter and filter the
table with some condition numbering lost it's continious increasing. is
there any way (user function, built-in function or formula) to keep
continious numbering while in autofilter.

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html