Thanks for taking a look at my problem.
I have a table filled with Yes and No values. I need a formula that will locate all cells with "Yes" value and index the row (Apples, Orange, Pear) and column (Molly, Joe, Sarah) headers used to define the cell.
Then take the defined row and column information and put it into two columns on a second worksheet.
My Yes/No Table on worksheet 1:
Molly Joe Sarah
Apples Y N Y
Orange N Y N
Pear Y N N
What I want it to look like on worksheet 2:
Column A Column B
Molly Apples
Molly Pear
Joe Orange
Sarah Apple
Aucun commentaire:
Enregistrer un commentaire