Largest value in a range
Thank you Bob, but I want to return the negative sign, so in the example I
gave the number returned must be -11. If -11 was not there then the largest
would be 10.
Milos.
"Bob Phillips" wrote in message
...
Miles,
Not non-array, but simpler
=MAX(ABS(A1:A100))
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"Milos Setek" wrote in message
...
Hi all,
Is there a nice non-array formula (or a more efficient array formula) to
compute the largest value (positive or negative) in a range such as this
one:
-5, 2, 0, -2, 10, -11.
In this case the answer is -11.
I use this formula but I think there should be something better than
that.
{=IF(MAX(range)=MAX(ABS(range)),MAX(range),-MAX(range)))}
Thanks for any tips.
Milos.
|