Min If
Perhaps something like:
If(your criteria, Min(A1:P100),"No")
HTH Otto
"Aaron" wrote in message
...
I am looking for a function that is a lot like SUMIF function but is Min
if.
Returns the min in a range by criteria.
Range, Criteria, and Min range
Any help would be great.
Thanks in advance!
Aaron
|