The ABS fuction returns the Absolute Value of a number. Basically, it just
strips off any negative signs, treating all numbers as positve.

The use of an Array Formula, tells Excel to apply the function (in this
case, ABS) to each individual cell in the range, rather than to the range as
a whole.

HTH,
Elkar

"fodman" wrote:


Excellent, works perfectly.

Could you please explain that Formula?


--
fodman
------------------------------------------------------------------------
fodman's Profile: http://www.excelforum.com/member.php...o&userid=31941
View this thread: http://www.excelforum.com/showthread...hreadid=552422