| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Arithmetical Mode of Criteria in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
| Lookup values in a column and display them in order with no gaps | Excel Worksheet Functions | |||
| can excel find the last used line in a column and display it? | Excel Worksheet Functions | |||
| Column in CSV file contains "03/04" should not display as 3-Apr -. | Excel Discussion (Misc queries) | |||
| How do I multiply Column G Totals by a number and display the res. | Excel Discussion (Misc queries) | |||
Threaded Mode
