| 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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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 |
|
#5
|
|||
|
|||
|
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 |
|
#6
|
|||
|
|||
|
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 |
| Reply |
| 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) | |||
Linear Mode
