Who went to both USA & UK? [Excel Challenge]

How about a fun Excel challenge? I have data in below format in the table named trips

I want to know which employees visited both USA & UK?

How would you solve this problem? Post your solutions in the comments.

Need sample data & my solution? Click here to download the file.

Want more challenges & home-work problems? See this page.

The post Who went to both USA & UK? [Excel Challenge] appeared first on Chandoo.org – Learn Excel, Power BI & Charting Online.