I have list of countries (column B), names (Column Y), date of birth (Column S)
For each country, I need to get oldest person date of birth and his name. I got the Max birth date correctly .. but cannot get the corresponding name. I did the following:
Oldest Person in a given country (A2): ---> {=MAX(IF(B:B=A2,S:S))} This is working perfectly.
Corresponding Name : ---> {=MAX(IF(B:B=A2,offset(S:S,0,2,1,1)))} but it is not working!!

Can someone help please?

Best regards,