MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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