First time poster, long time reader 
Platform: Excel 2010
My report resembles the attached image
The list is about 40 deep. The data, pulled from a program, is pasted into sheet 1 and everything is countifs into the appropriate cell on sheet 2 for the pretty report you see above.
My new ask to add to my report is a new section that would say China top 3 issues: (300) - 23, (400) 17, (3100) - 3 etc. The another for Japan and other countries. Next month, when the new data is pasted, it would update the top 3 issues per country. The allegation types are all unique and there may be a tie for any of the places.
I'm not comfortable enough with VBA.
Any ideas?

Platform: Excel 2010
My report resembles the attached image

The list is about 40 deep. The data, pulled from a program, is pasted into sheet 1 and everything is countifs into the appropriate cell on sheet 2 for the pretty report you see above.
My new ask to add to my report is a new section that would say China top 3 issues: (300) - 23, (400) 17, (3100) - 3 etc. The another for Japan and other countries. Next month, when the new data is pasted, it would update the top 3 issues per country. The allegation types are all unique and there may be a tie for any of the places.
I'm not comfortable enough with VBA.
Any ideas?
Last edited: