Darthshearer
Can't get enough of FH
- Joined
- Dec 22, 2003
- Messages
- 1,585
Hi All
After having a gander through google I am still stuck with Excel.
Anyway I have several Angles that I need to get the mean from and then input this into survey info.
I can work out the mean but would like it to be put into excel.
I have put in the following into a cell to work out the Degress Mins Second of an angle.
=Convert_Degree(P4)
I got this with This macro I found.
Anyway I have 2 sets of angles and I want to know how I would get the mean?
I am well confuzzled
I also want when I have 2 sets of mean angles to take one away from another?
Anyone got any ideas?
After having a gander through google I am still stuck with Excel.
Anyway I have several Angles that I need to get the mean from and then input this into survey info.
I can work out the mean but would like it to be put into excel.
I have put in the following into a cell to work out the Degress Mins Second of an angle.
=Convert_Degree(P4)
I got this with This macro I found.
Anyway I have 2 sets of angles and I want to know how I would get the mean?
I am well confuzzled
I also want when I have 2 sets of mean angles to take one away from another?
Anyone got any ideas?