Absolute Max
Posted by Roy Mickelsen on November 23, 1999 2:28 PM
I'm trying to determine the MAX value of a row of both negative and positive numbers. However, I need the result on an ABSOLUTE basis without regard for the sign.
Posted by Ivan Moala on November 23, 1999 9:32 PM
Assuming your range to evaluate is D5:D12 then
Try this ArrayFromula {=MAXA(ABS(D5:D12))}
Enter it without the {} THEN press Ctrl + Shift + Enter
Ivan
