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

This came from Leila Gharani
Original Video
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
Kevin (Array Formulas, Helper Columns, MIN, FIND).
Then I show 2 solutions:
– Formulas (COUNTIFS, INDEX)
– Get & Transform (Unpivot)

Take a look!


My book: Guerrilla Data Analysis 2nd Edition
My old blog:

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *