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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
minimum value using auto filter
Do you mean you want SUBTOTAL() to give you the minimum value of a filtered
list: If so try: =SUBTOTAL(5,Range) -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "mohavv" wrote in message oups.com... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
minimum value using auto filter
IT is usuful to use subototal if you are using filter.
SUBTOTAL(function_num, ref1, ref2, ...) Function_num 1 AVERAGE 2 COUNT 3 COUNTA 4 MAX 5 MIN 6 PRODUCT 7 STDEV 8 STDEVP 9 SUM 10 VAR 11 VARP "mohavv" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
minimum value using auto filter
A look in the help index for SUBTOTAL would have told you.
=subtotal(105, yourrange) -- Don Guillett Microsoft MVP Excel SalesAid Software "mohavv" wrote in message oups.com... 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 |
Reply |
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) |