What's the remaining number?

[stockgoblin42]

hi,

given 5 numbers, 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?

[:) Sixthsense :)]

What is your expected output? Please attach a sample workbook for better understanding

[stockgoblin42]

i guess i want the number that matches the others the least...

[:) Sixthsense :)]

May be this..

In D8 Cell

Please Login or Register  to view this content.

[stockgoblin42]

What's the logic used with this formula?

[stockgoblin42]

try:

36.84897086
56.88596761
48.64314951
30.88368484
59.4898376


48.64314951 is the oddball, but how by formula?