Finding closest index/match from LAT/LON without REPEATS

Administrative Note:

Welcome to the forum.

Unfortunately, it has come to our attention you have violated Rule #8 of our Forum RULES:

Don't private message, visitor message or email Excel (or Access, Word, etc.) questions to moderators or other members.

All questions and answers will benefit other posters like yourself when discussed in public threads. The point of having a public forum is to share solutions to common (and sometimes uncommon) problems with all members.

Breaking this rule is considered harassment by most of our contributors and thus cannot be tolerated. Repeat offence could lead to a permanent ban, so do take this caution to heart.

Hi LBook and welcome to the forum.

Sorry you got slapped with the rules, but I did too when I first started.

I have an answer for you, but you will need to learn about the Solver Tool. In Solver there is an "Add Constraint" dialog where all possible solutions need to be Different ("dif" in the dialog). If you match your points 1 to 9 up with points A through K and calculate a Sum of distances between the matches, Solver might give you the answer you want.

Think of the problem like this: Start matching 1 with a random letter points and calculate the distance between those two points. Then move to point 2 and match with any of the letters left. At the end you can calculate the Sum of the total distances between all matched points. Do the above a few thousand times and keep the pairings that is smallest. I used to do this random matching using VBA, then I discovered the Solver tool. Your goal in solver is to make the Sum of the random distances a minimum and have all the points be different.

Watch a youtube video or two like: https://www.bing.com/videos/search?q...tail&FORM=VIRE or
https://www.bing.com/videos/search?q...tail&FORM=VIRE
I think you want the Evolutionary Method with a "dif" in the constraints.

Hopes this gives you a place to start your study.