Finding distance between multiple coordinates relative to a single coordinate

[GreatMacca]

So I have over 100 points that I need to find the distance to from a single Cartesian point. I was hoping someone out there could help me find a way to only have to put the coordinates in and have Excel work out the answers. I have done a little bit of work with Excel but am totally lost here. Thank you in advance.

 

[3PlankWalker]

<title>Excel Jeanie HTML</title>Hi, Try this

Sheet1

	A	B	C

<tbody>
[TD="bgcolor: #cacaca, align: center"]1[/TD]
[TD="align: center"]X[/TD]
[TD="align: center"]Y[/TD]

[TD="bgcolor: #cacaca, align: center"]2[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]Origin[/TD]

[TD="bgcolor: #cacaca, align: center"]3[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]2.236068[/TD]

[TD="bgcolor: #cacaca, align: center"]4[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]-1[/TD]
[TD="align: center"]2.236068[/TD]

[TD="bgcolor: #cacaca, align: center"]5[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]6.708204[/TD]

[TD="bgcolor: #cacaca, align: center"]6[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]8.944272[/TD]

[TD="bgcolor: #cacaca, align: center"]7[/TD]
[TD="align: center"]-5[/TD]
[TD="align: center"]-10[/TD]
[TD="align: center"]11.18034[/TD]

[TD="bgcolor: #cacaca, align: center"]8[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]12[/TD]
[TD="align: center"]13.41641[/TD]

[TD="bgcolor: #cacaca, align: center"]9[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]14[/TD]
[TD="align: center"]15.65248[/TD]

[TD="bgcolor: #cacaca, align: center"]10[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]-16[/TD]
[TD="align: center"]17.88854[/TD]

</tbody>

Formeln der Tabelle

Zelle Formel C3 =SQRT(($A$2-A3)^2+($B$2-B3)^2) C4 =SQRT(($A$2-A4)^2+($B$2-B4)^2) C5 =SQRT(($A$2-A5)^2+($B$2-B5)^2) C6 =SQRT(($A$2-A6)^2+($B$2-B6)^2) C7 =SQRT(($A$2-A7)^2+($B$2-B7)^2) C8 =SQRT(($A$2-A8)^2+($B$2-B8)^2) C9 =SQRT(($A$2-A9)^2+($B$2-B9)^2) C10 =SQRT(($A$2-A10)^2+($B$2-B10)^2) <tbody> </tbody>

<tbody>
</tbody>

Distance Between Two points = SQRT((X2-X1)^2+(Y2-Y1)^2)