Hello and thanks so much for your time!
I'm about to be a judge in a fishing tournament for the first time, and the online system the organization uses is designed to rank winners based on simple things like length and weight. However, this tournament determines its winners...differently.
- First, Second, and Third place winners go to the people who catch at least 3 different species of fish (from five eligible species) and will be ranked on the total inches of the longest fish from each eligible category.
- The Most Valuable Angler goes to the person who catches at least 4 different species of fish (from five eligible species) and will be ranked on the total inches of the longest fish from each eligible category.
- The Top Team will go to the team who catches the greatest number of inches of eligible fish. (Edit: I think I've figured this one out already!)
As a result, it took them FOREVER to figure out who won. To avoid the same fate this year, I am trying to figure out how to automatically determine and show the winners. Luckily, I have last year's spreadsheet and tried to use pivot tables, but am not having much success.
Any and all help is much appreciated and I really am grateful to you for your time!
-JS
Bookmarks