Use the UNIQUE formula based on multiple criteria

[maxim642]

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.

 

[Fluff]

How about

Fluff.xlsm
	A	B	C	D	E	F
1	Employee Type	Gender	Active	Nationality
2	Permanent	Male	Yes	French		French
3	Permanent	Male	Yes	French		German
4	Contract	Female	No	Spanish		Spanish
5	Permanent	Male	Yes	German
6	Permanent	Female	Yes	Spanish
7
Main

Cell Formulas
Range	Formula
F2:F4	F2	=UNIQUE(FILTER(D2:D100,(A2:A100="permanent")*(C2:C100="yes")))
Dynamic array formulas.