Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
filter
Hi and sorry for my english
when i use the authomatic filter i need that the results are numbered in a near column. Is it possible? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
filter
zolabus,
For example, insert a new column A, and put this formula into cell A2 =SUBTOTAL(3,$B$2:B2) Then copy down to match your unfiltered list. When you filter, the numbers will update. HTH, Bernie MS Excel MVP "zolabus" wrote in message ... Hi and sorry for my english when i use the authomatic filter i need that the results are numbered in a near column. Is it possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why won't advanced filter return filter results? | Excel Worksheet Functions | |||
How do I use advanced filter to filter for blank cells? | Excel Discussion (Misc queries) | |||
Excel auto filter doesn't recoginize case - won't filter AA from A | Excel Discussion (Misc queries) | |||
"Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions | |||
advanced filter won't allow me to filter on bracketed text (-456.2 | Excel Discussion (Misc queries) |