Determine if a value in a range is close to the value of another c
 

Hi!

Is there a way to determine if there is a number in a range of values that
is closest in value to another number? I have a column of numbers that I
have used to calculate an average, but now I want to find out which of those
numbers is closest to the average.

Thanks!
--
Ray