Excel Forum

Excel Magic Trick 716: Max of Absolute Values MAX & ABS functions Array Formula

See how to find the Absolute Value Max of a set of integers (positive, zero and negative) using the MAX and ABS functions. Array formula.
Download file: http://people.highline.edu/mgirvin/

Got a Question? Ask it Here in the Forum.