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
