Formula for reviewing multiple cells and returning variable into a new cell

[charlee808]

A download I received has the female, male and couple in three different columns (D, E, F). If the response in the row is answered by a female, the word female shows up in the female column, and so on for male and couple. I would like to create a single column which reviews these three columns and puts a 0 for male, 1 for female, and 2 for couple in the newly created column.

[hemesh]

Hello Charlie! Could you post a sample workbook for better understanding with results shown manually

[Debraj Roy]

Hi ..

just a blind shot.. by assuming.. only cell is filled in a case..

In G1.. use formula as..

Please Login or Register  to view this content.

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.