| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto Numbering Test Scores and want ties to count the same
I have a series of 300 test scores from students and want them automatically
numbered from 1-300 based on best to worst. The problem is I want identical scores to number the same. i.e. say after number 10 the next three have identical scores I want all of those to number 11 and then the following score to be numbered 14. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Auto Numbering Test Scores and want ties to count the same
=RANK(A1,$A$1:$A$300)
"Scott" wrote: I have a series of 300 test scores from students and want them automatically numbered from 1-300 based on best to worst. The problem is I want identical scores to number the same. i.e. say after number 10 the next three have identical scores I want all of those to number 11 and then the following score to be numbered 14. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Auto Numbering Test Scores and want ties to count the same
Sort the scores in descending order (assuming they are in Col E)
Enter 1 agains the highest score (assuming you want the rank in Col F) Enter =IF(E2=E1,F1,F1+1) in the cell below that and copy till end "Scott" wrote: I have a series of 300 test scores from students and want them automatically numbered from 1-300 based on best to worst. The problem is I want identical scores to number the same. i.e. say after number 10 the next three have identical scores I want all of those to number 11 and then the following score to be numbered 14. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Auto Numbering Test Scores and want ties to count the same
Use the RANK function.
55 55 49 22 18 =RANK(A1,A$1:A$5) Copied down Returns 1;1;3;4;5 -- Biff Microsoft Excel MVP "Scott" wrote in message ... I have a series of 300 test scores from students and want them automatically numbered from 1-300 based on best to worst. The problem is I want identical scores to number the same. i.e. say after number 10 the next three have identical scores I want all of those to number 11 and then the following score to be numbered 14. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto select highest 25 scores. | Excel Worksheet Functions | |||
| Converting Test Scores to somewhat of a Linear Transformation | Excel Worksheet Functions | |||
| Calculate mean of test scores from rows of test answers | Excel Discussion (Misc queries) | |||
| comparing test scores over a few years | Excel Discussion (Misc queries) | |||
| Calculating Percentiles of Test Scores? | Excel Discussion (Misc queries) | |||
Linear Mode
