# Selecting the highest value between different items

Hello,

I have different values that shows the distance from a place (A) to other places (B, C, D…).
I need to select the 3 closest value among this cells and retrieve the name of the place (which is the name of the column).
I could find the highest value using the formula Min but i only get the closest one and it provides the value but I need the column’s one.

Is there any possibility to achieve this ?

Thanks for any help !
Guillaume

Hello @Krunchy !

You would need to create and use formula columns that compares the locations that you have.

A way to do that ( not the most efficient but easily understood) :

The 4 formulas are :

AND({Numbers}>{Numbers 1},{Numbers}>{Numbers 2})
AND({Numbers 1}>{Numbers 2},{Numbers 1}>{Numbers})
AND({Numbers 2}>{Numbers 1},{Numbers 2}>{Numbers})
IF({Formula 2}=“true”,{Numbers},IF({Formula 3}=“true”,{Numbers 1},IF({Formula 4}=“true”,{Numbers 2})))

Hope this helps!

Giannis, Implementation Consultant at thespelas.com

Thank you very much for your help.
I haven’t tried it yet but I’ll let you know if that works !
Guillaume