Autofilter - display column showing visible row count

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

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

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

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

Thanks very much -

Richard

Happy to hear
Thanks for the feedback
Ola Sandström

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 wrote:
> 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
>
>


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