» Calculating the Absolute Difference between Each List Value and the Minimum Value in the List
CATEGORY - Excel Formula and Function
VERSION - All Microsoft Excel Versions
For each value in List1 (column A), we want to calculate the absolute difference between it and the minimum value in the list.
Solution:
Use the ABS and MIN functions in the following formula:
=ABS(MIN($A$2:$A$8)-A2)
Book Store:
No comments have been submitted.
