Avatar of Chris Stormer
Chris Stormer

asked on 

Sort & Score A Range of Values in Excel

I have a table that has a range of values like:

https://docs.google.com/spreadsheets/d/1PeStssumF6D1LrJG1Nhz91QPctYR4lALUUpVZWR6_Vc/edit?usp=sharing

I am trying figure out how to automatically assign the score value by having it look at the range of all of the values and put the number in.

So if we have 6 names, each has a number associated with it, and I want to score them highest to lowest, with the highest having the largest number (6)  how can I do this in excel?


Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
byundt

8/22/2022 - Mon