» 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
Problem: 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:
Recommended Books:
No comments have been submitted.
