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

Thanks it works.

Do you have any idea why the last row of the table is always visible after
using the autofilter even don't match any filtering criteria.


Thanks

Haldun


"Debra Dalgleish" , haber iletisinde sunlari
...
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