I want to set up an excel spreadsheet that does the following:
Tracks the best marks of an athlete and puts in their corresponding meet...
B2: Finds the lowest (or highest) number in the row (I figured that out using MIN and MAX formulas),
B3: In the next column have the corresponding header go with the min or max that it just formulated...
ie if you have data B4:H4,
A4=Meet 1, A5=Meet 2, A6= Meet 3, etc
and B4=3, B5=2, B6=1
then B2 would be the lowest score (B6)
and B3 would be Meet 3
Any help is appreciated!
Bookmarks