I have a set of data that has Country, Company, Job Title, and a Count of available people. I want to return the top 3 companies with the highest count per country, per job title. I thought to use the LARGE function, but this returns the top 3 values for ALL countries/job titles. I am trying to use an IF statement within the large excel function to filter the count range based on the country/job title, but i can't seem to work out how.
Solved by F. Y. in 28 mins