Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I get "minimum value" in a range to NOT return zero?
I'm trying to keep the =MIN from returning 0 as the minimum value. Is this
possible? |
#2
|
|||
|
|||
Hi Blade
try =SMALL(C1:C10,COUNTIF(C1:C10,0)+1) where C1:C10 is the range you're looking for the minimum in. Cheers JulieD "Blade" wrote in message ... I'm trying to keep the =MIN from returning 0 as the minimum value. Is this possible? |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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? |
#5
|
|||
|
|||
Here's one way:
=MIN(IF(A1:A7<0,IF(MOD(ROW(A1:A7),2)=1,A1:A7))) This is an array formula and must be entered with CTRL+SHIFT+ENTER. On Tue, 1 Feb 2005 08:21:10 -0800, "Blade" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Passing a range name as an argument to the Index Function | Excel Discussion (Misc queries) | |||
Minimum value in a range > 0 | Excel Discussion (Misc queries) | |||
Function to return the latest non-zero value in a range of cells . | Excel Worksheet Functions | |||
lookup - return minimum value | Excel Worksheet Functions | |||
Excel: How to return count for each cell within date range criter. | Excel Worksheet Functions |