Hi all,
I'm having an excel sheet with 10 existing columns (each column represent one owner).
The values 1 and 2 in the cells stand for Male or Female.
IMG_1137 (1).JPG
Now I have to create dummy variables,
where Dummy1=1 when the group consist of 2 people; 1 male and 1 female
where Dummy2=1 when the group consist of 2 people with equal gender
where Dummy3=1 when the group consist of 3 or more people (disregard gender)
Could anyone please help me with a formula for this?
My aim is to create a new column for each dummy, where value is 0 or 1.
Thanks in advance!
Bob
Bookmarks