Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert wind direction to degrees
I'm sure this is a simple problem but I'm stupid. I have a
column with wind direction (N,NNE,NE...) and I need to convert it to a numerical representation (0,22.5,45...). The spreadsheet has about 20,000 rows so I need to automate this. I have a mental picture how this needs to happen but I have no idea of the syntax necessary. Set a counter Read a cell If cell is empty quit Select Case statement Assign degree value to variable Write variable to adjacent cell Increment counter Do again Can anyone out there help me get started. I can get the select statements but I have no idea how to programatically read and write to cells. Thanks, Larry |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Plotting wind speed and direction on a compass? | Charts and Charting in Excel | |||
Average Wind Direction | Excel Worksheet Functions | |||
correcting wind direction data | Excel Discussion (Misc queries) | |||
Average wind direction | Excel Discussion (Misc queries) | |||
wind direction | Excel Discussion (Misc queries) |