Numbering rows when using AutoFilter.
Posted by Zeke Crowley on June 18, 2001 3:37 PM
I've used Data=>Filter=>AutoFilter and now have the information I'm looking for. I have a column called "Item No." and would like use this column to sequentially number the rows that are visible after I run the AutoFilter. This is for reference and to display the total number of row meeting the AutoFilter criteria.
How do you do this? I tried doing an Edit=>Fill=>Series
but "Series" wasn't even available. Help if you can.
Posted by Russell on June 18, 2001 3:48 PM
Another Angle
Instead of numbering the rows, just use this formula (while your data is filtered) to get the number of filtered rows (must be in a column that does not have missing <blank> cells):
=Subtotal(3,E1:E5000) - for example
Posted by Mark W. on June 19, 2001 7:39 AM
Zeke, let's assume that you're filtering B1:B11
which contains {"Field1";"A";"B";"C";"D";"A";"A";"C";"D";"C";"C"}.
If you enter the formula, =SUBTOTAL(3,$B$2:B2),
into cell A2 and Copy down to cell A11. Then
column A becomes your 'Item No.' column.
