v |
A |
B |
C |
D |
E |
F |
1 |
name |
points |
location |
|
|
|
2 |
John |
450 |
Washington |
Washington |
=MAXIFS($B$2:$B$19,$C$2:$C$19,D2) |
=INDEX($A$2:$A$19,MATCH($E$2:$E$5,$B$2:$B$19,0)) |
3 |
Lisa |
124 |
Washington |
New York |
=MAXIFS($B$2:$B$19,$C$2:$C$19,D3) |
=INDEX($A$2:$A$19,MATCH($E$2:$E$5,$B$2:$B$19,0)) |
4 |
Sam |
96 |
Washington |
San Francisco |
=MAXIFS($B$2:$B$19,$C$2:$C$19,D4) |
=INDEX($A$2:$A$19,MATCH($E$2:$E$5,$B$2:$B$19,0)) |
5 |
Rupert |
483 |
Washington |
Kansas |
=MAXIFS($B$2:$B$19,$C$2:$C$19,D5) |
=INDEX($A$2:$A$19,MATCH($E$2:$E$5,$B$2:$B$19,0)) |
6 |
Raymond |
222 |
Washington |
|
|
|
7 |
Daniel |
394 |
New York |
|
|
|
8 |
Josh |
182 |
New York |
|
|
|
9 |
Liam |
44 |
New York |
|
|
|
10 |
Frank |
203 |
San Francisco |
|
|
|
11 |
Alex |
112 |
San Francisco |
|
|
|
12 |
Adam |
456 |
San Francisco |
|
|
|
13 |
Michael |
342 |
San Francisco |
|
|
|
14 |
Richard |
231 |
San Francisco |
|
|
|
15 |
Kyle |
505 |
Kansas |
|
|
|
16 |
Jordan |
100 |
Kansas |
|
|
|
17 |
Jess |
87 |
Kansas |
|
|
|
18 |
Sarah |
42 |
Kansas |
|
|
|
19 |
Lindsay |
310 |
Kansas |
|
|
|
Bookmarks