I have a long list of >1000 individuals with their travel history to multiple countries and would like to tally for each country how many of them have visited it.
See below or the attachment for a simplified example. I tried to pivot or to use "countifs", but neither seems to be able to count. Any suggestion ?
ID country
Jane France
Jane Japan
Jane US
Pete Brazil
Pete Egypt
Pete Japan
Pete UK
Pete US
Tom Brazil
Tom France
Tom UK
Tom US
Bookmarks