I have a table of scores below, its a lot larger with more names, dates and scores in a sheet called 'Data'. Some cells may be blank, which I've marked below. I have formulas to extract the high score per person across all dates per a sheet called 'Personal Best'.
I need to extract the date of the highest score per person given the name and high score (the earliest date, in the event of two tied high scores). Basically extract the first cell value in the row, given the column header and data point in that column. Since the table is quite large, if you can assume say 1000 rows and columns out to BB, that would be helpful. Thank you in advance for any help!!
Personal Best sheet
A5: Adam
B5: 199
C5: [extract date]
A6: Bob
B6: 214
C6: [extract date] - note: ability to copy the formula down for other names/scores
Data sheet
(blank) (blank) (blank) Adam Bob John Mike Joe
10/4/12 info Game 1 (blank) 177 193 (blank) 124
10/4/12 info Game 2 (blank) 192 128 (blank) 156
10/4/12 info Game 3 (blank) 202 158 (blank) 193
10/4/12 info Game 4 (blank) 155 169 (blank) 164
10/4/12 info Game 5 (blank) 214 192 (blank) 160
10/4/12 info Game 6 (blank) 200 208 (blank) 191
10/4/12 info Game 7 (blank) 182 226 (blank) 134
10/11/12 info Game 1 113 202 150 169 (blank)
10/11/12 info Game 2 146 159 144 150 (blank)
10/11/12 info Game 3 120 134 194 117 (blank)
10/11/12 info Game 4 138 119 175 145 (blank)
10/11/12 info Game 5 161 178 158 131 (blank)
10/11/12 info Game 6 199 151 142 182 (blank)
10/11/12 info Game 7 166 180 144 162 (blank)
10/18/12 info Game 1 150 186 164 184 (blank)
10/18/12 info Game 2 158 166 172 153 (blank)
10/18/12 info Game 3 130 157 202 146 (blank)
10/18/12 info Game 4 135 188 215 146 (blank)
10/18/12 info Game 5 113 202 150 169 (blank)
10/18/12 info Game 6 146 159 144 150 (blank)
10/18/12 info Game 7 (blank) (blank) (blank) (blank) (blank)
Bookmarks