L
Legacy 352679
Guest
Wondering if someone can help me find the most efficient way to figure out a really basic math brain fart I'm having.
Column H has wind speed data.
Column I has the degrees the wind is blowing in.
Column J has the respective wind direction as N, NNE, NE, ENE etc.
How can I group wind speeds together (i.e. 0-10, 10.1-20 etc) to find out the percentage of direction. So, what percentage of wind between 0-10 is blowing N, what percentage of wind between 10.1-20 is blowing N, what percentage of wind between 0-10 is blowing east etc.
Column H has wind speed data.
Column I has the degrees the wind is blowing in.
Column J has the respective wind direction as N, NNE, NE, ENE etc.
How can I group wind speeds together (i.e. 0-10, 10.1-20 etc) to find out the percentage of direction. So, what percentage of wind between 0-10 is blowing N, what percentage of wind between 10.1-20 is blowing N, what percentage of wind between 0-10 is blowing east etc.