Employee Type | Gender | Active | Nationality |
Permanent | Male | Yes | French |
Permanent | Male | Yes | French |
Contract | Female | No | Spanish |
Permanent | Male | Yes | German |
Permanent | Female | Yes | Spanish |
I would like a formula that shows a list of the unique nationalities of permanent employees that are active (Yes).
Thank you.