Retrieve The Correct Column Header (Leila Gharani Kevin Lehrbass Excel Challenge)

This came from Leila Gharani
Original Video https://youtu.be/OJLfPc9YlqE
Then Kevin Lehrbass took it on:

The challenge:
You have data in a matrix. Locate a specific piece of data and retrieve the name of the column it’s in.

This is tougher than you might think.

This video is a glimpse of the solutions from
Leila (COLUMN, SUMPRODUCT and INDEX) and
Kevin (Array Formulas, Helper Columns, MIN, FIND).
Then I show 2 solutions:
– Formulas (COUNTIFS, INDEX)
– Get & Transform (Unpivot)

Take a look!

Website: https://ozdusoleil.com

My book: Guerrilla Data Analysis 2nd Edition
http://www.amazon.com/Guerrilla-Analysis-Using-Microsoft-Excel/dp/1615470336
My old blog: http://datascopic.net/blog-2-2