I am trying to analyze data from a survey I completed earlier. I am probably using excel extremely inefficiently, but I wanted to use a statement that allows me to sort for two different things at once. Right now, I am using the following:
IF (L78=AA$1, 1,0)
to determine if an item in column L is the same as the header I created in column AA. But what I would like to do is create a similar IF statement that allows me to compare items in two separate columns, and if the condition is true, then put the contents of a third column in the space.
Any help is greatly, greatly appreciated.