Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Ranking
I'm working on a spreadsheet that scores on five different categories and
weighing them differently. I've figured out the scoring part and the weighing part but now I'd like to have Excel automatically rank the scores by putting a 1, 2, 3 in a cell beside the individual's name. Can this be done? Thanks, Tom |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Ranking
So assuming you have something like:
Name Cat1 Cat2 Cat3 Cat4 Cat5 Weight You want to then add another column for Rank? If so, no problem. Add the column header Rank, then for each row, write the formula: =Rank(my_weight_cell,weight_range) Replace "my_weight_cell" with the cell weight value for that person. Replace the "weight_range" with the range of cells in the Weight column. NOTE: If you make the weight_range absolute (e.g. $E$2:$E$10 - the $ tells Excel not to change the row/column when you copy the formula) then you can write the formula for the first row and copy it to all the other rows. "Charter" wrote: I'm working on a spreadsheet that scores on five different categories and weighing them differently. I've figured out the scoring part and the weighing part but now I'd like to have Excel automatically rank the scores by putting a 1, 2, 3 in a cell beside the individual's name. Can this be done? Thanks, Tom |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Ranking
On Sun, 7 Dec 2008 11:36:39 -0600, "Charter"
wrote: I'm working on a spreadsheet that scores on five different categories and weighing them differently. I've figured out the scoring part and the weighing part but now I'd like to have Excel automatically rank the scores by putting a 1, 2, 3 in a cell beside the individual's name. Can this be done? Thanks, Tom Assuming your scores are in cells A1 to A10. Try this formula in cell B1: =RANK(A1,A$1:A$10) Copy it down to B10. (The 10 should be changed to fit the number of rows in your score column) Hope this helps / Lars-Åke |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with ranking | Excel Discussion (Misc queries) | |||
Ranking | Excel Worksheet Functions | |||
ranking | Excel Worksheet Functions | |||
ranking over a sum | Excel Worksheet Functions | |||
ranking | Excel Worksheet Functions |