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 ...
Just use the RANK.EQ or RANK.AVG function in another column.
=RANK.AVG(L1,$L$1:$L$10,0)
=RANK.AVG(L1,$L$1:$L$10,0)
