hi,

given 5 number datasets, how would I find the 2 numbers that are closest, the 2 numbers that are second closest and not the 1st pair and the last number remaining?

ex)

5

6

23

27

120 ***

so 2 numbers are the closest to each other (5&6), a different two are the second closest (23&27) and I want to know the one that doesn't pair up with any of the others (120).

any ideas for formula?