Excel Challenge & Meditation | Isolate the winners of split-decisions

You have a list of contests and the decisions made by the judges in 3 columns, like this:

Contest1: Goblins – Sharks – Sharks
Contest2: Penguins – Thunder – Penguins

How can use Excel to show that the Sharks won Contest1 and the Penguins won Contest2?

That’s the challenge. This video includes a meditation and time to think about how you’d isolate the winners from 20 contests.

#DynamicArrays
#ExcelChallenge
#ExcelMeditation

For a list of my Excel courses at Lynda/LinkedIn:
https://www.linkedin.com/learning/instructors/oz-du-soleil
There are courses on Power Query, Good spreadsheet habits, and a weekly Excel challenge that comes out every Friday.

Website: https://ozdusoleil.com

My book: Guerrilla Data Analysis 2nd Edition

My old blog: http://datascopic.net/blog-2-2