find a bearing from point a to point b

[Madman]

hi and thanks for reading this
just a (hopefuly) quick question
How do i find a bearing from A to B?
but B changes down the list
i need the bearing so i can use on a map

mikethemad

 

[shg]

Compass bearing (i.e., CW from N) from A to B is

=DEGREES(ATAN2(yb-ya, xb-xa))

 

[Madman]

not really what i asked for but thanks
how do i put this in to words
ok i will try
i have this

<table height="68" border="0" cellpadding="0" cellspacing="0" width="479"><colgroup><col style="mso-width-source:userset;mso-width-alt:1280;width:26pt" width="35"> <col style="mso-width-source:userset;mso-width-alt:3072;width:63pt" width="84"> <col style="mso-width-source:userset;mso-width-alt:4754;width:98pt" width="130"> </colgroup><tbody><tr style="height:12.75pt" height="17"> <td class="xl72" style="height:12.75pt;width:26pt" height="17" align="center" width="35">Ref</td> <td class="xl73" style="width:63pt" align="center" width="84">51.52011667</td> <td class="xl73" style="width:98pt" align="center" width="130">-0.4768</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl73" style="height:12.75pt" height="17" align="center">1</td> <td class="xl73" align="center">51.51666667</td> <td class="xl73" align="center">-0.4775</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl73" style="height:12.75pt" height="17" align="center">2</td> <td class="xl73" align="center">51.52226667</td> <td class="xl73" align="center">-0.489333333333333</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl73" style="height:12.75pt" height="17" align="center">3</td> <td class="xl73" align="center">51.52095</td> <td class="xl73" align="center">-0.4905</td> </tr> </tbody></table>
so i need the bearing from
ref to 1
ref to 2
ref to 3
and so if this happens
madman

 

[shg]

Would you like to explain what those numbers are, or should I continue to guess?

 

[shg]

I'll continue to guess.

If they are latitudes and longitudes, this is approximately correct ...

      --A-- ---B--- ---C--- -D--
  1   Point   Lat    Long   Brg 
  2   Ref   51.5201 -0.4768     
  3      1  51.5167 -0.4775 187 
  4      2  51.5223 -0.4893 285 
  5      3  51.5210 -0.4905 276

The formula in D3 and down is

=MOD(DEGREES(ATAN2(B3-$B$2, (C3-$C$2) * COS(RADIANS($B$2)))), 360)

 

[Madman]

sorry for being so late to reply
but they are latitudes and longitudes
mike

 

[Madman]

thanks that works now
thanks again for your help
mike