Good morning, everyone!

I have a formula where I need to count the number of duplcate entries for a
particular name where it matches up with a particular country. See below:

Column A Column E
----------------------------------------

Australia AB 111
Australia XXX 011
Australia AC 211
Australia XXX 011
India XXAE 211
India AB 111

I need to make the answer say Australia has 3 unique entries for Column E.

Can anyone assist?

Thanks!
Stacy