| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Filter Operation
Tom
Many thanks for elegant solution, as ever Best wishes Tim "Tom Ogilvy" wrote in message ... =if(subtotal(9,SheetB!F2:F3000)<Sum(SheetB!F2:F30 00),"Data if filtered","Data is not Filtered") pick a column that has no blanks and is composed of numbers. Or you could use CountA (and subtotal(3,range)) as opposed to sum (and Subtotal(9,range)) -- Regards, Tom Ogilvy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Ghost Data/Large Operation | Excel Discussion (Misc queries) | |||
| DataFilterAuto Filter in excel 2007? | New Users to Excel | |||
| Data - Filter - Auto Filter | Excel Discussion (Misc queries) | |||
| Do same operation on an entire column and put the data in the col itself | Excel Discussion (Misc queries) | |||
| "Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions | |||
Threaded Mode
