Cheers you've save me hours of work!

"Niek Otten" wrote:

Make a table in two columns like this:
0 N
11.25 NNE
33.75 NE
56.25 ENE
78.75 E
101.25 ESE
123.75 SE
146.24 SSE
168.75 S
191.25 SSW
213.75 SW
236.25 WSW
258.75 W
281.25 WNW
303.75 NW
326.25 NNW
348.75 N

With the degrees (as a normal number) in C1:
=VLOOKUP(C1,$A$1:$B$17,2)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel



"UniStudent Coll" <UniStudent wrote in message
...
|I have compass bearing wind direction forecast measurements with an accuracy
| to one degree. Which is being compared to obserevd wind directions which is
| recorded in the 16 points of the compass.
|
| Using EXCEl 2007 I need to convert the forecast into the same format with
| the following intervals to convert into the name next to it:
|
| 348.75-11.24 N
| 11.25 - 33.74 NNE
| 33.75 - 56.24 NE
| 56.25 - 78.74 ENE
| 78.75 - 101.24 E
| 101.25 - 123.74 ESE
| 123.75 - 146.24 SE
| 146.24 - 168.74 SSE
| 168.75 - 191.24 S
| 191.25 - 213.74 SSW
| 213.75 - 236.24 SW
| 236.25 - 258.74 WSW
| 258.75 - 281.24 W
| 281.25 - 303.74 WNW
| 303.75 - 326.24 NW
| 326.25 - 348.74 NNW
|
| The other problem is that it is in degrees and im not sure if this will work
| in this format in excel? ANy help would be greatly appreciated....