Quiz Score Sheet
I’m a novice, I have created a excel worksheet to use at our church quiz night. I have 10 teams in first column, then 10 columns to put results in as the quiz rounds are played. I then have a total ...
Forum Discussion
Hi gigantic
In attached file a Table with 10 teams:
If you need more teams just add them starting row 13, the Table size will auto-adjust
Dense Rank is just another ranking option. If you don't want/like it just delete that column
In Dense Ranking, items that compare equally receive the same ranking number, and the next item(s) receive the immediately following ranking number
This has worked great! With a few months of use there are a couple things that would be cool to add but I can't figure it out without messing up the table's calculations. I'm trying to add a halftime total as well as a final total (pre-final question). Any suggestions?
- No time these days (sorry) + quite old thread. Better you create a new one with a realistic sample attached (or shared) + the expected result. Thanks