minimum value using auto filter

[mohavv]

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

 

[Sandy Mann]

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Guest]

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

 

[Don Guillett]

A look in the help index for SUBTOTAL would have told you.
=subtotal(105, yourrange)