Numbering Rows in Filtered Data - Excel 2002

  • Thread starter Thread starter mng5829
  • Start date Start date
M

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,

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?
 
in A2:
=SUBTOTAL(3,B$1:B1)
and fill down

mng5829 said:
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?
Click to expand...
 
Back
Top