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


--
rgarber50
------------------------------------------------------------------------
rgarber50's Profile: http://www.excelforum.com/member.php...o&userid=11350
View this thread: http://www.excelforum.com/showthread...hreadid=390153

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


--
olasa
------------------------------------------------------------------------
olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760
View this thread: http://www.excelforum.com/showthread...hreadid=390153

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
------------------------------------------------------------------------
rgarber50's Profile: http://www.excelforum.com/member.php...o&userid=11350
View this thread: http://www.excelforum.com/showthread...hreadid=390153

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

Thanks very much -

Richard


--
rgarber50
------------------------------------------------------------------------
rgarber50's Profile: http://www.excelforum.com/member.php...o&userid=11350
View this thread: http://www.excelforum.com/showthread...hreadid=390153

If you use Excel's DataSubtotals 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

Happy to hear
Thanks for the feedback
Ola Sandström


--
olasa
------------------------------------------------------------------------
olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760
View this thread: http://www.excelforum.com/showthread...hreadid=390153