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

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

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

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