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!
No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.
Your password has been sent to:firstname.lastname@example.org
To follow this tag...
Thanks! We'll email you when relevant content is added and updated.
Share this item with your network: