Thanks, this works great when selecting a range like A1:A:10
Is there different syntax for selecting individual cells like A1, A3, A5, A7
where A1, A3, A5, A7 represent values for a separate calculation?
"Peo Sjoblom" wrote:
If there are only positive values
=LARGE(A1:A10,COUNTIF(A1:A10,"0"))
if there can be negative values
=MIN(IF(A1:A10<0,A1:A10))
note that the latter formula MUST be entered with ctrl + shift & enter
Regards,
Peo Sjoblom
"Blade" wrote:
I'm trying to keep the =MIN from returning 0 as the minimum value. Is this
possible?
|