Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAFirst time posting my solution here !
As for the other, I don't have the same results on the third question.
Pivot wide to the required format probably took me most work 😅
Thanks
I am not able to post the screenshot and workflow but here are my answers.
1) Who was the winner among the male and female contestants for each year?
Year | Men | Hot Dogs Eaten | Women | Hot Dogs Eaten |
2015 | Matthew Stonie | 62 | Miki Sudo | 38 |
2016 | Joey Chestnut | 70 | Miki Sudo | 38 |
2017 | Joey Chestnut | 72 | Miki Sudo | 41 |
2018 | Joey Chestnut | 74 | Miki Sudo | 37 |
2019 | Joey Chestnut | 71 | Miki Sudo | 31 |
2020 | Joey Chestnut | 75 | Miki Sudo | 48.5 |
2) How many hog dogs did the winners eat?
Men - 424 and Women - 233
3) What year had the least number of hot dogs eaten by a man and a woman?
Men Year | Least amount eaten | Women Year | Least amount eaten |
2016 | 1 | 2018 | 4 |
All,
This week, I have submitted a 2-for-1, in that I have a long version and a short version of solutions that both work thereby proving that you really can skin a cat two different ways.
The shorter solution focuses more on isolating the numbers required in the end and then utilizing the summation tool for that before cleaning the data later.
-The longer solution focuses on creating and cleaning the table first and then using a smooth and clean table for use by the summation table.
-Nonetheless, both use:
1 Multi-Row Formula
2 Formula
Multiple Data Cleaning Tools