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.