Calculate Compass Heading between Points

Can you attached your file here, please? I don't see on snap any sensitive data so should be ok.

Getting bearings should still be simple trig. I find that a lot of trig is easier if I understand the unit circle. I made a spreadsheet here to illustrate the unit circle in Excel: https://www.excelforum.com/tips-and-...ml#post4309792 I think the trickiest part of this for many will be the switch from the standard "angles are referenced to the positive x axis" convention that standard trig uses and the compass bearing convention where angles are referenced to the positive y axis (north). I recommend you spend a few minutes with the unit circle and compass bearing convention to make sure you understand what is happening.

Once you have a handle on that, then getting compass bearing from your data points becomes a simple ATAN2() function: https://support.office.com/en-us/art...8-c96b3a565033 Recognizing that y is now the equivalent of the x (cosine) argument and x is now the equivalent of the y (sine) argument, the angle from point 1 to point 2 is simply ATAN2(M3,L3).

Then you must remember that, like all programming languages, Excel does trig in radians, so you need to convert the result from radians to degrees. DEGREES(ATAN2(M3,L3)). Then note that the ATAN2() output is -pi() to +pi() radians (-180 to +180 degrees) -- and most who deal with compass bearings want output from 0 to 360. Usually this is accomplished with a MOD() function =MOD(DEGREES(ATAN2(M3,L3)),360)