Calculating distant between two coordinate points

I request a template or formulas to calculate the distant between coordinate points (114,50 and 54,91 etc).
However I am going to use this for a game and going to be used by clan members as well.
Here is how it works:
The left area contains names and the coordinates of "targets". (about 20+ targets)
The user would enter their coordinates or a current location in a certain box.
Then distant between the coordinates entered and the target's (all of them) coordinates will show.

Sorry if this is badly worded and I am somewhat new the excel.

Note:This is possible, I recall using something similar to what I have stated above but under certain circumstances I am unable to get the template off him.

Thanks in advance.

This is simple geometry and Pythagorus. The distance-squared is the sum of the difference in y coordinates squared plus the difference in x coordinates squared, i.e.

distance = SQRT((Y2-Y1)*(Y2-Y1) +(X2-X1)*(X2-X1))

Hope this helps.

Pete

Thank you for your response, but I want to use that using excel...on a bigger scale. I just want to enter a set of coordinates in a box and it will calculate the distant between the entered coordinates and each of the 20+ coordinates.

So, you have 20+ fixed coordinates and you want to know the distance between each of those and some new coordinate?

If so, put your fixed coordinates in columns A and B starting on row 3, and use C1:D1 for your new coordinates. Then put this formula in D3:

=SQRT(($C$1-A3)^2 + ($D$1-B3)^2)

and copy it down to cover your 20+ fixed coordinates. It will give you the distances, then you can put a new set of coordinates in C1:D1, etc.

Hope this helps.

Pete