Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
formulas
Hi,
I am working in as a school teacher and next to compile scores for student and rank then as 1st 2nd 3rd Pls guide me to create a excel table and once the scores are input in, the person who got the highest score will be shown as 1st then 2nd will be shown as 2nd and so on... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
formulas
Just simply list the names in one column, scores in another, and use RANK to
rank them, such as =RANK(B2,$B$2:$B$50) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "William Sim" <William wrote in message ... Hi, I am working in as a school teacher and next to compile scores for student and rank then as 1st 2nd 3rd Pls guide me to create a excel table and once the scores are input in, the person who got the highest score will be shown as 1st then 2nd will be shown as 2nd and so on... |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
formulas
Thanks Bob,
This RANK functions comply individual scores and rank them accordingly but I need to show only the 1st, 2nd & 3rd of the whole score table example: Name: Matthew Mark Luke John Sco 5 3 2 4 1st: "matthew" 2nd: "John" 3rd: "Mark" "Bob Phillips" wrote: Just simply list the names in one column, scores in another, and use RANK to rank them, such as =RANK(B2,$B$2:$B$50) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "William Sim" <William wrote in message ... Hi, I am working in as a school teacher and next to compile scores for student and rank then as 1st 2nd 3rd Pls guide me to create a excel table and once the scores are input in, the person who got the highest score will be shown as 1st then 2nd will be shown as 2nd and so on... |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
formulas
William,
There are a number of things that you could do once you have the overall rank. You could conditionally format the top 3, maybe with different colours, which can highlight them within the main table, or you could use a formula to create another list of the top 3, such as =IF(ISERROR(SMALL(IF(C1:C20<4,ROW($A1:$A20),""),RO W($A1:$A20))),"", INDEX($A$1:$A$20,SMALL(IF(C1:C20<4,ROW($A1:$A20)," "),ROW($A1:$A20)))) This is a block-array formula, so select a range of say 5 cells and enter this block-array formula in the formula bar, then commit with Ctrl-Shift-Enter. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "William Sim" wrote in message ... Thanks Bob, This RANK functions comply individual scores and rank them accordingly but I need to show only the 1st, 2nd & 3rd of the whole score table example: Name: Matthew Mark Luke John Sco 5 3 2 4 1st: "matthew" 2nd: "John" 3rd: "Mark" "Bob Phillips" wrote: Just simply list the names in one column, scores in another, and use RANK to rank them, such as =RANK(B2,$B$2:$B$50) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "William Sim" <William wrote in message ... Hi, I am working in as a school teacher and next to compile scores for student and rank then as 1st 2nd 3rd Pls guide me to create a excel table and once the scores are input in, the person who got the highest score will be shown as 1st then 2nd will be shown as 2nd and so on... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert Array Formulas to Regular Formulas | Excel Worksheet Functions | |||
Counting # of Formulas in a column with formulas and entered data | Excel Worksheet Functions | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
AdvancedFilter on cells with formulas, returning values and not formulas | Excel Programming |