formulas

[Guest]

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...

 

[Bob Phillips]

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)

 

[Bob Phillips]

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),""),ROW($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)