I've created a spreadsheet to tabulate scores for a band competition.
I need formulas to extract the high score in different classes and
categories.

Class Band "Drum Major" "Color Guard" "Dance Line"
Majorettes
1A Abbeville 85 86
1A New Brockton 85 73
85 86
1A Dale County 82 90 86
2A Early County 90 93 78
2A W.S. Neal 92 93 90
2A Russell County 97 88
3A Geneva 85 81 88
3A Valley 87 97 88


Best in Class 1A 2A 3A
Drum Major Rehobeth Early County
Geneva
Color Guard Freeport W.S. Neal Geneva
Dance Line Saint James W.S. Neal
Majorettes Slocomb W.S. Neal
Andalusia
Ex. I need the formula to extract the high score for Drum Major in
Class 1A. How do I do this? Thanks