Autofilter - display column showing visible row count

[rgarber50]

I want to autofilter a list. In the column directly to the left of the
filtered list I would like to consecutively number each of the visible
rows in the filtered list.
So if i have a list with headers in b1 and c1 and data entered in b2
and c2 ....
and the filtered list has 3 items in it.
then I'd like to see:

A1: No B1: Header1 C1: Header2
A2: 1 B2: 1234 C2: ABCD
A3: 2 B3: 1234 C3: FGHI
A4: 3 B4: 1234 C4: JKLM

Is this even possible?

Thanks
Richard

 

[olasa]

Yes it is possible, and not to difficult.
Put this in the first column: =SUBTOTAL(3,$A$2:A2) and copy down

Hope it helped
Ola Sandström

 

[rgarber50]

Hi -
When I try your formula in column A [the header is No - so formula
starts in A2 then I get 0 as the result for A2. And it still isn't
showing consecutive numbers in descending rows. Am I doing something
wrong?

Richard


Yes it is possible, and not to difficult.
Put this in the first column: =SUBTOTAL(3,$A$2:A2) and copy down

Hope it helped
Ola Sandström

 

[rgarber50]

Ola
Hi - the formula works of course!
I just entered it into the wrong column.

Thanks very much -

Richard

 

[Debra Dalgleish]

If you use Excel's Data>Subtotals feature, you should remove the column
of "numbering" subtotals before you apply the Subtotals feature.

Otherwise, your table may be deleted when you remove the Subtotals feature.

 

[olasa]

Happy to hear
Thanks for the feedback
Ola Sandström