I have a spreadsheet that lists per line products that have been purchased from a particular source and country.
I have ranked the sources and the countries separately based on the total number of products purchased.
I would now like to have a table that lists the Top sources and the the Top 2 countries for that source. I've got the top sources part but for the the life of me I can't figure out how to list the top 2 countries for those sources.
Hoping someone can help or point me in the right direction.
I've attached my test spreadsheet below.
Thanks.
I have ranked the sources and the countries separately based on the total number of products purchased.
I would now like to have a table that lists the Top sources and the the Top 2 countries for that source. I've got the top sources part but for the the life of me I can't figure out how to list the top 2 countries for those sources.
Hoping someone can help or point me in the right direction.
I've attached my test spreadsheet below.
Thanks.
