Difference in values
 

Have a column with many numbers, need difference between low value and high
value, while ignoring zeros...can this be done? thx.
--
Just because you can, doesn't mean you should.

Difference in values
 

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"ayeFayze" wrote in message
...
Have a column with many numbers, need difference between low value and
high
value, while ignoring zeros...can this be done? thx.
--
Just because you can, doesn't mean you should.

Difference in values
 

=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
--
Gary''s Student - gsnu200766


"ayeFayze" wrote:

Have a column with many numbers, need difference between low value and high
value, while ignoring zeros...can this be done? thx.
--
Just because you can, doesn't mean you should.

Difference in values
 

Very much obliged...no way I would have figured that out...
--
Just because you can, doesn''t mean you should.


"Gary''s Student" wrote:

=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
--
Gary''s Student - gsnu200766


"ayeFayze" wrote:

Have a column with many numbers, need difference between low value and high
value, while ignoring zeros...can this be done? thx.
--
Just because you can, doesn't mean you should.