Sort:  

Now I know why my nested IF statements didn't work. I never considered the order of the criteria. Thanks for this Paula.

Useful!

Sometimes I try to do too much with SQL, and I could be pulling the raw data a bit more and doing things like this. Cheers :)

Excel rocks when you know how to really use it :-) My SQL is not good at all and would be lost without excel and power bi

Congratulations @theexcelclub! You have completed the following achievement on the Steem blockchain and have been rewarded with new badge(s) :

You published more than 30 posts. Your next target is to reach 40 posts.
You received more than 500 upvotes. Your next target is to reach 1000 upvotes.

Click here to view your Board of Honor
If you no longer want to receive notifications, reply to this comment with the word STOP

To support your work, I also upvoted your post!

Support SteemitBoard's project! Vote for its witness and get one more award!