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

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

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

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