Pulling data from multiple MS Forms spreadsheets & displaying into single league table

Hello everyone,

As part of the Olympics celebrations, we've created a couple of trivia quizzes using MS Forms for colleagues. Each MS Forms quiz outputs the results into an excel spreadsheet. From the outputted spreadsheet, the main info I need are:

• Name
• The points
• The amount of time each person took in minutes/seconds
• The ranking/sorting from best to worst for each quiz (in score points & quickest time)
• The ranking/sorting from best to worst from both quizzes combined (in score points & quickest time)
• Then tally this up against both the quizzes done to see who is the winner

I can't attach the 2 quiz files to this post, so instead I've uploaded them to file.io sharing website and the link is: https://file.io/V6H0LhOORR91

Any help would be greatly appreciated.

Thank you.

Here's the link to the same question asked in another forum thread: Mr Excel

Administrative Note:

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so. Cross-posts are allowed but you must provide a link to your posts on other sites.

Please see Forum Rule #7 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important: https://excelguru.ca/a-message-to-forum-cross-posters/

(Note: this requirement is not optional. No help to be offered until you provide a link or, for members with fewer than 10 posts, a comment telling us where else you have posted this query.)

Hello @AliGW.

Sorry about that. I've not been on this forum for a while, so I forgot. I've added the link to the other forum at the bottom of my original post. I hope that's okay, but let me know if you want it amending. Thank you.

Thank you. This particular rule is the same everywhere.

@excelnewbie999

You should post the crosspost link to the other site on this forum also.

No help to be offered until you provide a link

I see the crosspost now. Thanks you.