Forum Discussion
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 ...
Hello! I stumbled across your sheet and think it would work well for a neighborhood trivia night I'm setting up. I can't figure out how to adjust the rank area so I can add more teams. I'm also a bit puzzled by the "dense rank" column. What was the intended purpose? Thanks in advance!
Michael
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