I am trying to run an analysis to score a certain number of points, depending on whether or not a company was voted best (4 points), second (3 points) and third (2 points) within a certain country. All the points then get summed by per company per country and then the sum of points is assigned a rank. I am assuming I should be using AGGREGATE function to achieve this? What would be the best way of running this analysis? I know how to do ranking based on the sum of points, but if I wanted to do ranking on a country level, would I need to split the file first and then do the ranking and similarly on a global level? Thank you very much!!!!
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!