| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
minimum value using auto filter
I am trying to get a minimum value from a column using auto filter
I can't get the formula to only look in the filtered (visible) values, like =SUBTOTAL(9,range) It keeps giving me the lowest value from the total column. Is there a solution? Cheers, Harold |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto Count for Auto Filter Doesn't Function under certain circumst | Excel Discussion (Misc queries) | |||
| Auto Number the Rows of Auto Filter Result | Excel Discussion (Misc queries) | |||
| Auto minimum on Y Axis | Charts and Charting in Excel | |||
| in data/filter/auto filter | Excel Worksheet Functions | |||
| Excel auto filter doesn't recoginize case - won't filter AA from A | Excel Discussion (Misc queries) | |||
Threaded Mode
