Challenge #325: How many hot dogs can you eat?

[valentinmarechal]

First time posting my solution here !

As for the other, I don't have the same results on the third question.

スポイラ

[atcodedog05]

My take on this

スポイラ

[LiuZhang]

スポイラ

Pivot wide to the required format probably took me most work 😅

[NW_Cms]

スポイラ

Thanks

[namans0297]

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

[RanierMoore]

スポイラ

[aakashraj]

Here you go.

[megianoli]

This is my solution, :)

[dbrownsc]

スポイラ

[Reesetrain2]

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