Rank maximum based on multiple criteria

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.

Attachment 145003

Hi Nasman,

Welcome to the forum.

I have checked the attachment and found that you have used Rand function in the worksheet and because of that values keeps on changing.. any reason for that?
Also, do you want the formula to be applied on L7:O8.. basis the criteria that if K7 is "Seek".. you need the country's name from column C against which max. number of "Seek" is listed in column D.... this will be for column L? and after getting the country name, you need the count of that country in column M?

I would suggest you to remove the Rand function (for the time being) and put your results manually and post the file back .. and I will try to obtain the similar results using formulas. thanks

Regards,
DILIPandey

<click on below 'star' if this helps>