Difference in values

[ayeFayze]

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

 

[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))

 

[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

 

[ayeFayze]

Very much obliged...no way I would have figured that out...