Excel formula returning multiple values according to two criterias

Question

I'm seeking for a formula (without VBA) that can, for example, show the places in Column F where there are persons with the same names in Column G and the same birthdays in Column H.

I tried combining INDEX + Fit with COUNTIF or VLOOKUP, but either I only had the first Location match the list's requirements or I got an error.

Answer 1

Unique Column Cells With Two-Column Duplicates

=LET(rCol,F2:F16,uCol1,G2:G16,uCol2,H2:H16,
    uAll,uCol1&","&uCol2,uOnce,UNIQUE(uAll,,1),rBol,ISERROR(XMATCH(uAll,uOnce)),
UNIQUE(FILTER(rCol,rBol)))

I hope this helps you.