Hello,
I wasn't sure exactly how to word the title of this post, so hope it wasn't too confusing.
I have a spreadsheet outputted from a survey program. There are multiple columns that indicate all of the possible values that were available to answer a question. The selected answer is indicated with a '1' in the appropriate column. I'd like to use a function that will select the column header based on the cell that contains the '1'.
Please see the attached sample spreadsheet which shows the original columns and the new columns that represent the desired results. I need to know what formula would yield those results.
Thanks so much for your help!
Ed Self
Bookmarks