hello all!!!

this is my first post here! i hope someone can help me

am working a project in excel for a cabin allocation.

basically i have finish it already but the only thing is missing its an IF or variable formula that gives me if a female or male are sharing the same cabin and if yes to show it as COUPLE

in Excel i have all my employees list with cabin number and gender.

is there any formula i can use to tell excel that if she find a Male & Female in the same cabin it should give me "Couple" status?

thank you all for your help

luca