Here is a suggestion. Subtract each field in the test Range
from the corresponding field in the target Range
. Take the absolute value of each result and sum them. The Range
with the smallest total wins. The absolute value of x can be found using Math.Absolute(x)
. A more sophisticated method would be to express the absolute value as a percentage of the maximum possible value of that field.