Hello
I have a list of names and their respective 'entry' saved as X,Y co ordinates.
I am struggling to find the correct formula to display a list of 20 people who are closest to the winning co ordinates. Lets say the winning co ordinates are 1332,169. I want to be able to find the top 20 people who were closest to those winning co ordinates from a list.
xy.JPG
this list has mock data in by the way.
Is there anyway I can search through to see the closest 20 entries?
Bookmarks