Distance Between Points with Lat Long and Get Average

[Smerdis13]

Hi Guys,
I Have one Excel file with Different Points with Lat Long which categorized in some AREA
I Need Excel VBA Code to:
-Get Distance between Points in each Area
-Get Minumum Distance for Each Point
-Get Average of Minimum Distances for Each Area
-Give Table for results based on Each Area and Average Distance
Sampe Image attached
Thanks in advance Guys

 

[DRSteele]

This can all be done with formulas. Do you really need VBA? If so, I can't help, but I do know the formula solution.

 

[Smerdis13]

This can all be done with formulas. Do you really need VBA? If so, I can't help, but I do know the formula solution.

Thanks Dear
I Needed VBA to do the process based on Area and give results, not to check points each one by one
but it is appreciated if you share formula solution as well