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|
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
Multiple Data Cleaning Tools