Excel Forum
Similar Content
MAX and MIN Values from a Filtered List in Excel
Tutorial: How to get the MAX and MIN values from a filtered data set. This method returns the value ...
Create a Custom Function in Excel - UDF
Tutorial: How to create a custom worksheet function in Excel. These are called User Defined Function...
Count the Number of Unique Values in a List in Excel
Tutorial: Use a formula to count the number of unique values that are contained within a list in Exc...



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.