Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
counting rows
I have 100 rows in a column A which are numbered 1 -100 in numical order.
After I filter a particular item in column B which results in 20 rows (and these 20 item were scattered throughout the column), I would like column A to show 1 - 20 in numerical order. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
counting rows
Try this...
Assume the data in column B is in the range B2:B1010 with B1 being the header. Enter this formula in A2 and copy down to A101: =SUBTOTAL(3,B$2:B2) -- Biff Microsoft Excel MVP "Darryl" wrote in message ... I have 100 rows in a column A which are numbered 1 -100 in numical order. After I filter a particular item in column B which results in 20 rows (and these 20 item were scattered throughout the column), I would like column A to show 1 - 20 in numerical order. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
counting rows
Assuming you have headers in row 1 and the 100 items are in range B2:B101, -
in cell A2 type: =SUBTOTAL(103,$B$2:B2) and copy down along the range. Try, now, to filter an item in column B. Micky "Darryl" wrote: I have 100 rows in a column A which are numbered 1 -100 in numical order. After I filter a particular item in column B which results in 20 rows (and these 20 item were scattered throughout the column), I would like column A to show 1 - 20 in numerical order. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting 'up' rows instead of down | Excel Discussion (Misc queries) | |||
Counting rows | Excel Worksheet Functions | |||
Counting characters in multiple rows when rows meet specific criteria | Excel Worksheet Functions | |||
Counting Rows | Excel Discussion (Misc queries) | |||
Counting rows, then counting values. | Excel Discussion (Misc queries) |