Help Please with setting up a quiz scoresheet
 

I have set the sheet to add teammnames , rounds etc and used the fucntions to
total the scores for each team etc.

What i want to do if possible is to be able to announce who is currently in
the lead at the end of each round by haveing the team scores automatically
listed from top (Highest score) to Bottom (Lowest Score) on the sheet.

Is this do able ?

Tahnx to anyoone that can help

Mark

Help Please with setting up a quiz scoresheet
 

Sounds like you'll want to take a look at the RANK function, or the LARGE
function, depending on how you want results displayed.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"MarkChambers" wrote:

I have set the sheet to add teammnames , rounds etc and used the fucntions to
total the scores for each team etc.

What i want to do if possible is to be able to announce who is currently in
the lead at the end of each round by haveing the team scores automatically
listed from top (Highest score) to Bottom (Lowest Score) on the sheet.

Is this do able ?

Tahnx to anyoone that can help

Mark

Help Please with setting up a quiz scoresheet
 

Got me lost now lol

I'll just look up and down the totals. I think there are only a dozen or so
teams.

Thanks again for your time taken to reply

"Luke M" wrote:

Sounds like you'll want to take a look at the RANK function, or the LARGE
function, depending on how you want results displayed.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"MarkChambers" wrote:

I have set the sheet to add teammnames , rounds etc and used the fucntions to
total the scores for each team etc.

What i want to do if possible is to be able to announce who is currently in
the lead at the end of each round by haveing the team scores automatically
listed from top (Highest score) to Bottom (Lowest Score) on the sheet.

Is this do able ?

Tahnx to anyoone that can help

Mark