Difference in values

A

ayeFayze

Have a column with many numbers, need difference between low value and high
value, while ignoring zeros...can this be done? thx.
 
D

Don Guillett

Try this array formula which cannot use the entire column and must be
entered using ctrl+shift+enter

=MAX(IF(O1:O100<>0,O1:O100))-MIN(IF(O1:O100<>0,O1:O100))
 
G

Gary''s Student

=MAX(IF(A1:A1000<>0,A1:A1000))-MIN(IF(A1:A1000<>0,A1:A1000))

this is an array formula and must be entered with CNTRL-SHFT-ENTER
rather then just
ENTER
 
Top