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
attached file contains both a pivot table and a countif formula solution
Last edited by alansidman; 12-06-2018 at 05:09 AM.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
A Pivot Table is the best way to go. See attached.
For a production version I suggest you use a dynamic range name that automatically adjusts to the length of your data and use the name as the source for the PT
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Hi AlanOriginally Posted by alansidman
Your attach is for other problem.
Jose
Thanks. I have updated correct file.
Thanks all for the help ! I realized that I failed to see Move to Values in pivotTable field dropdown and thus was struggling to see how pivottable can "count" the items.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks