Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Largest value in a range
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
FInding the largest number in a range meeting a criteria | Excel Discussion (Misc queries) | |||
Largest Value in a Range | Excel Discussion (Misc queries) | |||
Can I calculate a statistical range (largest minus smallest)? | Excel Discussion (Misc queries) | |||
Second largest value | Excel Discussion (Misc queries) | |||
Getting the 2nd largest or smallest valuesin a range | Excel Discussion (Misc queries) |