Hi All -
I have the following 2 formulas that have helped me to determine the top 2 scores and return the respective headers, but they aren't perfect and I need help.
- The above returns the max, however doesn't take into account scores that are a tie or 0 values
- The above returns the 2nd highest value, but some instances the output is correct (if there is a tie or a 0).
How can I fix both of these equations and also determine the 3rd highest score?
Your help would be appreciated!