See your other posts

Biff

"Eric" wrote in message
...
In cell A1 = 10
In cell A2 = 15
In cell A3 = 20
In cell A4 = 12
In cell A5 = 17
In cell A6 = 23

I would like to determine the minimum difference between any 2 numbers
from
above lists. Let assume all number must be positive, in this case, 12-10 =
2
and 17-15 = 2, there are 2 pairs of value to meet the minimum difference
between 2 numbers. Then I would like to determine the minimum median value
from those pairs, in this case (12+10) = 11, then the 11 will display in
cell
B1. Does anyone have any suggestion on how to do this calculation in
excel?
Thank you in advance
Eric Choi