Find Lowest Time, Match with Column Heading
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!
Re: Find Lowest Time, Match with Column Heading
Hope this helps,
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1