Scorecard for quiz

[stephen_]

Merry Christmas all,

I've been asked to run the works annual quiz and want to do the score's on a simple spreadsheet.

I'd like a 2nd table to be able to pick up the position each team is dynamically when the scores for each round are added.

See attached for the template - much help is appriciated!

[Melvinrobb]

I changed the rank formula to give unique rankings. if you need to make an additional column instead of replacing the rank column you could.

[stephen_]

@Melvinrobb - many thanks yet could I still use the simple rank function without unqies incase 2 teams have the same score at the end?

[Melvinrobb]

You just need to have two columns: one with unique rank and one with the rank I have made.
Then have the formulas reference the rank column I added.

[stephen_]

Many thanks.