The below table is in Sheet1. I have the date and the highest number in that date range in Sheet2. I need a formula in Sheet2 that can extract the column header if there are multiple (repetitive) dates in the row headers with the ability to copy down.
Extras: If there is a tie for high score a given date, is there a way to indicate this? Instead of the name, it returns "Tie"? Not critical
Sheet2
A1 = 1/1/2013
B1 = 271
C1 should extract "Ben" and should be able to copy this down rows (still assuming I provide the date and high game for the range for each row)
A2 = 1/8/2013
B2 = 277
C2 should extract "Adam" copied from C1
Sheet1
(blank) (blank) John Mike Adam Ben Paul
1/1/2013 Game 1 241 199 102 146 195
1/1/2013 Game 2 134 143 167 271 108
1/1/2013 Game 3 174 157 211 180 244
1/8/2013 Game 1 115 149 215 164 107
1/8/2013 Game 2 191 257 228 132 202
1/8/2013 Game 3 194 251 277 275 215
Thanks in advance!
Bookmarks