Finding closest index/match from LAT/LON without REPEATS

I am looking to find closest location without a duplicate...

I have a list of location I need to find a near site to REPLACE with a closest location, but not a duplicate from the search.

I have included a sample workbook and the formulas I had put in and have as reference. Please let me know if there is a way to populate the closest site with not including the last one listed if less than as the closest distance. I need unique values and tried to mess around with small and other functions and each example led to duplicates no matter where I searched within the forum for similar.

please also copy to [email


Thank you very much anybody willing to help out!!!!!