Does anyone have any suggestions on how to determine the minimum difference
between values?
There is a list of value under column A
307, 325, 343, 361, 381, 401, 421, 441
and there is a given value 400 in cell B1, I would like to determine the
minimum difference between 400 and the list of values, and it should return 1
in cell C1, because abs(400-401) = 1.
Does anyone have any suggestions on how to do it in Excel?
Thanks in advance for any suggestions
Eric