Thanks for the video. However, in the description under the video, there is a typo in the formula that screws formula slightly, but it's easy to miss. There is an additional "," after two brackets after the ROUND function. Use this if not sure: Wind8=CHOOSE(1+ABS(ROUND(O2/45,0)),"N","NE","E","SE","S","SW","W","NW","N")
Karin: You go to fast for anybody to follow what you say. Moreover, believe me no need to say (I'm going to...) all the time, just explain what is the purpose of what you do, and what you do is really great. I was agreeably astonished at the ease with which you play with certain complex issues in Excel. Congratulations, and thank you. I've another what to do almost the same task in Excel. It was tough to me to do it anyway.
Wind 2 - dividing the wind into two categories: North & South Wind 4 - dividing the wind into four categories: North, East, South & West Wind 8 - dividing the wind into eight categories: North, North-East, East, South-East, South, South-West, West, & North-West
Thanks for the video. However, in the description under the video, there is a typo in the formula that screws formula slightly, but it's easy to miss. There is an additional "," after two brackets after the ROUND function. Use this if not sure:
Wind8=CHOOSE(1+ABS(ROUND(O2/45,0)),"N","NE","E","SE","S","SW","W","NW","N")
could you tell me how can i get these data? for any location
hi, with office 2019 doesn't work how can i fix it?
pls help me
I'm using Excel 2019, and using your method it labels all of my wind directions as N even though they are definitely not
Did you ever find a fix ?
How do you change A1 point into a compass points.
Karin: You go to fast for anybody to follow what you say. Moreover, believe me no need to say (I'm going to...) all the time, just explain what is the purpose of what you do, and what you do is really great. I was agreeably astonished at the ease with which you play with certain complex issues in Excel. Congratulations, and thank you. I've another what to do almost the same task in Excel. It was tough to me to do it anyway.
Good morning from Cambodia, May I can convert the wind in direction into angle data, pls
This should do it. =VLOOKUP(A1,{"N",0;"NE",45;"E",90;"SE",135;"S",180;"SW",225;"W",270;"NW",315},2,FALSE)
When wind direction is 0 to 15 the code generated is 0
I'm sorry, what is the difference between wind 2, 4, and 8?
Wind 2 - dividing the wind into two categories: North & South
Wind 4 - dividing the wind into four categories: North, East, South & West
Wind 8 - dividing the wind into eight categories: North, North-East, East, South-East, South, South-West, West, & North-West
@@karinaadcock OMG thank you so muchhh!🙏🙏
it didn't work :(
Not a single use of the term "Excel" in the video name or description. How can you miss something SO obvious?