I am consolidating monthly photography scores for the year to show the category winners based on top 3 or 4 scores of a possible 10 scores. I've started a spreadsheet but I am stumped on the Summary tab on how to pull in the winners scores to the Summary tab. The Event Data tab is where the monthly data is pasted into. The monthly scores tab was an idea, but I'm not using it. The Summary tab is the real wanted results of this spreadsheet. The Calc tab is where the scores are by category with test data names across the top. The names across the top of the calc tab can be updated monthly when the latest scores come in.
I've uploaded my file to hopefully help with solutions.
I hope this explains what I am looking.
Thank you
Bookmarks