Minimum non-zero value
Are there any negative numbers in the range?
Try one of these:
=SMALL(A1:J1,COUNTIF(A1:J1,0)+1)
This one is an array formula** :
=MIN(IF(A1:J10,A1:J1))
** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT
key then hit ENTER.
--
Biff
Microsoft Excel MVP
"Derrick" wrote in message
...
I need to find the minimum non-zero value in a row of numbers - not
necessarily together
ie:
36, 0, 0, 24
i would like the resultant value to be 24
if there is a blank -
36, 0, 0, -
i would like it to be 36
any help?
|