Numbering Rows in Filtered Data - Excel 2002

[mng5829]

Hi,

I'm trying to figure out how to have filtered rows display consecutive
numbers instead of the actual row number.

For example, I have 200+ rows with different data and I use a filter to show
30 of these rows. I want the screen to number these rows as 1, 2, 3, etc.
instead of 3, 15, 26, 42, etc.

Please help!

 

[NBVC]

You can't change the actual Row numbers presented by Excel.. but you ca
add a formula that will number consecutively for you so that after yo
filter, you still get from 1,2,3, etc..

Try, in the 2nd row,

=SUBTOTAL(3,A$1:A2)-1

copied down.

This will give a 1 for the 1st row below headers...

after filtering, you should still see sequential numbering in tha
column

--
NBV

Where there is a will there are many ways.

'The Code Cage' (http://www.thecodecage.com

 

[mng5829]

NBVC,

I tried using the formula you gave me... I got an error message stating
that it cannot calculate because there is a circular reference.

Is there something else I can try or check?

 

[Bob Umlas]

in A2:
=SUBTOTAL(3,B$1:B1)
and fill down

NBVC,

I tried using the formula you gave me... I got an error message stating
that it cannot calculate because there is a circular reference.

Is there something else I can try or check?

 

[mng5829]

Bob,

Thank you sooo much!! This was perfect!!

in A2:
=SUBTOTAL(3,B$1:B1)
and fill down