About Us

UniStudent Coll[_2_]

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....

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I reshuffle some column data based on a coding scheme?	Motown Mick	Excel Discussion (Misc queries)	9	February 2nd 09 05:34 PM
How to fix the coding?	Eric	Excel Worksheet Functions	4	June 20th 07 02:42 PM
coding	maisy1	Excel Discussion (Misc queries)	1	August 6th 06 08:58 PM
Coding	metaltecks	Excel Discussion (Misc queries)	1	April 17th 06 10:12 PM
coding	Hardy	Excel Discussion (Misc queries)	1	February 22nd 05 04:58 PM

Menu

About Us