Return a column header based on text in a cell

Hi,

So I usually suck at explaining things, but I've googled this to death and I'm desperate, so here goes.

I have huge amount of data from a survey in an excel spreadsheet. The column headers are the labeled with the question numbers of the survey (Q1, Q2, Q3, so on). Each row has the name of the survey taker and the subsequent answers to the questions. For each individual survey taker, I need to know which questions they answered negatively. For example, if I have

Name Q1 Q2 Q3
John Doe Strongly Disagree Disagree Agree

Is there a way to use a formula or table to tell me that John Doe answered Q1 & Q2 "negatively" (with negatively being defined as somewhat disagree, disagree, or strongly disagree)?

Basically I want to find all the somewhat disagree, disagree, or strongly disagree answers in each row and return the column header of each cell that has any three of those values in it.

Hopefully I was clear enough to understand D:

Thanks!

Try this...

Data Range

	A	B	C	D	E
1		Q1	Q2	Q3	Q4
2	Sam	Agree	Agree	Agree	Disagree
3	Pam	Somewhat Disagree	Agree	Strongly disagree	Agree
4	Mam	Agree	Strongly Disagree	Agree	Disagree
5
6
7	Pam	Q1	Q3
8

This array formula** entered in B7:

=IFERROR(INDEX(1:1,SMALL(IF(ISNUMBER(SEARCH("Dis",INDEX($B2:$E4,MATCH($A7,$A2:$A4,0),0))),COLUMN($B2:$E4)),COLUMNS($B7:B7))),"")

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

Copy across until you get blanks.

You're welcome!