Spreadsheet: 198163-if-two-values-are-equal-index-to-return-name-that-match-on-cell-range-score-board-vlady
Sheet: Sheet1

 |  |  |  |  | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
9 | 9 | 1 Star |  |  | IF(A1="","",IF(B1="",NOW(),B1)) |  |  |  |  |  | Men's Round: |  |  | Heat:# |  |  |  |  |  |  |  |  |  |  | 5
 | Event Name > | "Corona Extra Pro Surf Circuit" |  |  | MAX(A1:A10,B1) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
 | Event Site > | Domes, [NAME]
 | Event Dates > | March 12, 13, 2011
Round # |  | Heat# | Colors |  |  |  |  | Position |  | Color |  |  | Points |  | Competitors Name
1 | [NAME] | 1 |  |  |  |  |  | 1st |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Waves Surfed:
 | [NAME] | US | Yellow |  |  |  |  | 2nd |  |  |  |  |  |  |  |  |  |  |  |  |  |  | of possible 40 |  | Excellent 8.5-10
 | [NAME] | PR | Red |  |  |  |  | 3rd |  |  |  |  |  |  |  |  |  |  |  |  | Largest Avrg | 10 Largest |  |  | Good 6.5-8.4
 | [NAME] | US | Blue |  |  |  |  | 4th |  |  |  |  |  |  |  |  |  |  |  |  | (4 largest of each color) | Average |  |  | Average 4-6.4
 | [NAME] | PR | White |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Evt |  |  |  |  | Two Best |  |  |  |  |  |  |  | Two Best |  |  |  |  |  |  |  |  |  |  |  | Total Waves Surfed
Sd |  |  |  |  | Waves |  |  |  |  |  |  |  | Waves
No# | Seed Order Below |  |  |  | Points: |  |  |  |  |  |  |  | Points:
1 | [NAME] | PR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Waves Surfed
2 | [NAME] | PR |  |  | Wave Count | [NAME]  1 | [NAME] | [NAME]  3 | [NAME] | [NAME]  5 | [NAME] |  | Wave Count | [NAME]  1 | [NAME] | [NAME]  3 | [NAME] | [NAME]  5 | [NAME] |  |  |  |  |  | 0
3 | [NAME] | PR |  |  | 1 | 3 | 3 | 3 | 3 | 3 |  |  | 1 | 8 | 4 | 4 | 4 | 4 |  |  |  |  |  |  | 0
4 | [NAME] | PR |  |  | 2 | 4 | 4 | 4 | 4 | 4 |  |  | 2 | 3 | 3 | 3 | 3 | 3 |  |  |  |  |  |  | 0
5 | [NAME] | PR |  |  | 3 | 5 | 5 | 5 | 5 | 5 |  |  | 3 | 9 | 9 | 9 | 9 | 9 |  |  |  |  |  |  | 1
6 | Hector Santa María | PR |  |  | 4 |  |  |  |  |  |  |  | 4 |  |  |  |  |  |  |  |  |  |  |  | 0
7 | [NAME] | PR |  |  | 5 |  |  |  |  |  |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  | 0
8 | Pablo Días | PR |  |  | 6 |  |  |  |  |  |  |  | 6 |  |  |  |  |  |  |  |  |  |  |  | 0
9 | [NAME] | PR |  |  | 7 |  |  |  |  |  |  |  | 7 |  |  |  |  |  |  |  |  |  |  |  | 0
10 | [NAME] | PR |  |  | 8 |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  |  |  |  |  | 0
11 | [NAME] | PR |  |  | 9 |  |  |  |  |  |  |  | 9 |  |  |  |  |  |  |  |  |  |  |  | 0
12 | [NAME] | PR |  |  | 10 |  |  |  |  |  |  |  | 10
13 | [NAME] | PR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] [NAME] | 5
14 | [NAME] | PR |  |  | Two Best |  |  |  |  |  |  |  | Two Best |  |  |  |  |  |  |  | Heat Points= sum of the | Heat Points
15 | [NAME] | PR |  |  | Waves |  |  |  |  |  |  |  | Waves |  |  |  |  |  |  |  | Best 2 avrg of each heat | High to low
16 | Moises Montalvo | PR |  |  | Points: |  |  |  |  |  |  |  | Points:
17 | [NAME] | PR
18 | [NAME] | PR |  |  | Wave Count | [NAME]  1 | [NAME] | [NAME]  3 | [NAME] | [NAME]  5 | [NAME] |  | Wave Count | [NAME]  1 | [NAME] | [NAME]  3 | [NAME] | [NAME]  5 | [NAME]
19 | [NAME] | PR |  |  | 1 | 10 | 10 | 10 | 12 | 10 |  |  | 1 | 4.5 | 4.5 | 4.5 | 4.5 | 4.5
20 | [NAME] Torres | PR |  |  | 2 | 7 | 7 | 7 | 7 | 7 |  |  | 2 | 5 | 5 | 5 | 5 | 5
21 | Ricardo Delgado | PR |  |  | 3 | 9 | 9 | 9 | 9 | 9 |  |  | 3 | 3 | 3 | 3 | 3 | 3
22 | Wilfredo Deliz | PR |  |  | 4 |  |  |  |  |  |  |  | 4 | 7 | 7 | 7 | 7 | 7
23 | Eduardo Roure | PR |  |  | 5 |  |  |  |  |  |  |  | 5
24 | [NAME] | PR |  |  | 6 |  |  |  |  |  |  |  | 6
25 | [NAME] | US |  |  | 7 |  |  |  |  |  |  |  | 7
26 | [NAME] | PR |  |  | 8 |  |  |  |  |  |  |  | 8
27 | Ramses Morales | PR |  |  | 9 |  |  |  |  |  |  |  | 9
28 | [NAME] | PR |  |  | 10 |  |  |  |  |  |  |  | 10
29 | [NAME] | PR
30 | [NAME] | PR
31 | [NAME] | US |  |  |  |  |  |  |  | Judges Statistics
32 | [NAME] | PR |  |  |  | Best 10 Waves |  |  |  | Best Average Heat Points |  |  |  | 20 | Stats After |  | 1 | Heats
33 | [NAME] | PR |  |  | 10 |  |  |  |  |  |  |  |  |  | Total of |  |  | Waves | [NAME]
34 | [NAME] | PR |  |  | 9
35 | Cristian Rivera Benítez | PR |  |  | 9 |  |  |  |  |  |  |  |  |  | Excel:
36 | Alejandro Moreda | PR |  |  | 7
37 | [NAME] | US |  |  | 7 |  |  |  |  |  |  |  |  |  | Good:
38 | [NAME] | PR |  |  | 5
39 | [NAME] | P.R. |  |  | 5 |  |  |  |  |  |  |  |  |  | [NAME]:
40 | [NAME] | PR |  |  | 4.5
41 | [NAME] | PR |  |  | 4 |  |  |  |  |  |  |  |  |  | Fair:
42 | Davey Stiles | PR |  |  | 4
43 | [NAME] | PR
44 | [NAME] | US |  |  | Round 2
45 | [NAME] | US |  |  | Positions |  | Colors |  |  | Scores |  |  |  |  | Competitors Name
46 | [NAME] | PR |  |  | 1st
47 | [NAME] | PR |  |  | 2nd
48 | [NAME] | US |  |  | 3rd
49 | [NAME] | PR |  |  | 4th
50 | [NAME] | PR |  |  |  |  |  | Yellow |  |  |  |  |  |  |  | Blue
51 | [NAME] | PR |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  | [NAME]
52 | [NAME] | Barb |  |  | Heat Pts. |  |  |  |  |  |  |  | Heat Pts.
53 | [NAME] | US
54 | [NAME] | US |  |  | Wave Count | Judge 1 | Judge 2 | Judge 3 | Judge 4 | Judge 5 | [NAME] |  | Wave Count | Judge 1 | Judge 2 | Judge 3 | Judge 4 | Judge 5 | [NAME]
55 | [NAME] | US |  |  | 1 | 1 | 1 | 1 | 1 | 1 |  |  | 1 | 1 | 1 | 1 | 1 | 1
56 | X |  |  |  | 2 | 5 | 5 | 6 | 6.5 | 4.5 |  |  | 2 | 1 | 1 | 2 | 1 | 1
57 | X |  |  |  | 3 | 4.5 | 5.5 | 4.8 | 6.3 | 5.5 |  |  | 3 | 5.5 | 5 | 5 | 5 | 6
58 | X |  |  |  | 4 | 7.5 | 8 | 8 | 7.8 | 7.5 |  |  | 4
59 | X |  |  |  | 5 | 1 | 2 | 2 | 1 | 1 |  |  | 5
60 | X |  |  |  | 6 | 1 | 2 | 1 | 1 | 1 |  |  | 6
61 | X |  |  |  | 7 |  |  |  |  |  |  |  | 7
62 | X |  |  |  | 8 |  |  |  |  |  |  |  | 8
63 | X |  |  |  | 9 |  |  |  |  |  |  |  | 9
64 | X |  |  |  | 10 |  |  |  |  |  |  |  | 10
 |  |  |  |  |  |  |  | Green |  |  |  |  |  |  |  | White
 |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  | Heat Pts. |  |  |  |  |  |  |  | Heat Pts.
 |  |  |  |  | Wave Count | Judge 1 | Judge 2 | Judge 3 | Judge 4 | Judge 5 | [NAME] |  | Wave Count | Judge 1 | Judge 2 | Judge 3 | Judge 4 | Judge 5 | [NAME]
 |  |  |  |  | 1 | 2 | 2.5 | 3 | 2.5 | 3 |  |  | 1 | 4.5 | 6 | 5 | 5 | 5
 |  |  |  |  | 2 | 4 | 5 | 5 | 6 | 4.5 |  |  | 2 | 3.5 | 3 | 4 | 2 | 3
 |  |  |  |  | 3 | 1 | 2 | 1 | 1 | 1 |  |  | 3 | 4 | 5.5 | 3.8 | 5.5 | 5.5
 |  |  |  |  | 4 | 7.2 | 6.5 | 6.8 | 6 | 7 |  |  | 4 | 4 | 5 | 4 | 4.5 | 5
 |  |  |  |  | 5 | 6 | 6 | 7 | 6.5 | 6 |  |  | 5 | 1 | 1 | 1 | 1.5 | 2
 |  |  |  |  | 6 |  |  |  |  |  |  |  | 6
 |  |  |  |  | 7 |  |  |  |  |  |  |  | 7
 |  |  |  |  | 8 |  |  |  |  |  |  |  | 8
 |  |  |  |  | 9 |  |  |  |  |  |  |  | 9
 |  |  |  |  | 10 |  |  |  |  |  |  |  | 10
 |  |  |  |  | Round 3
 |  |  |  |  | Positions |  | Colors |  |  | Scores |  |  |  |  | Competitors Name
 |  |  |  |  | 1st
 |  |  |  |  | 2nd
 |  |  |  |  | 3rd
 |  |  |  |  | 4th
 |  |  |  |  |  |  |  | Yellow |  |  |  |  |  |  |  | Blue
 |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  | Heat Pts. |  |  |  |  |  |  |  | Heat Pts.
 |  |  |  |  | Wave Count | Judge 1 | Judge 2 | Judge 3 | Judge 4 | Judge 5 | [NAME] |  | Wave Count | Judge 1 | Judge 2 | Judge 3 | Judge 4 | Judge 5 | [NAME]
 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 |  |  | 1 | 10 | 10 | 10 | 10 | 10
 |  |  |  |  | 2 | 5 | 5 | 6 | 6.5 | 4.5 |  |  | 2 | 1 | 1 | 2 | 1 | 1
 |  |  |  |  | 3 | 4.5 | 5.5 | 4.8 | 6.3 | 5.5 |  |  | 3 | 5.5 | 5 | 5 | 5 | 6
 |  |  |  |  | 4 | 7.5 | 8 | 8 | 7.8 | 7.5 |  |  | 4
 |  |  |  |  | 5 | 1 | 2 | 2 | 1 | 1 |  |  | 5
 |  |  |  |  | 6 | 1 | 2 | 1 | 1 | 1 |  |  | 6
 |  |  |  |  | 7 |  |  |  |  |  |  |  | 7
 |  |  |  |  | 8 |  |  |  |  |  |  |  | 8
 |  |  |  |  | 9 |  |  |  |  |  |  |  | 9
 |  |  |  |  | 10 |  |  |  |  |  |  |  | 10
 |  |  |  |  |  |  |  | Green |  |  |  |  |  |  |  | White
 |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  | Heat Pts. |  |  |  |  |  |  |  | Heat Pts.
 |  |  |  |  | Wave Count | Judge 1 | Judge 2 | Judge 3 | Judge 4 | Judge 5 | [NAME] |  | Wave Count | Judge 1 | Judge 2 | Judge 3 | Judge 4 | Judge 5 | [NAME]
 |  |  |  |  | 1 | 2 | 2.5 | 3 | 2.5 | 3 |  |  | 1 | 6 | 7 | 6 | 6.5 | 7
 |  |  |  |  | 2 | 4 | 5 | 5 | 6 | 4.5 |  |  | 2 | 4.5 | 4.5 | 5.5 | 5 | 4.8
 |  |  |  |  | 3 | 1 | 2 | 1 | 1 | 1 |  |  | 3 | 4 | 5.5 | 3.8 | 5.5 | 5.5
 |  |  |  |  | 4 | 7.2 | 6.5 | 6.8 | 6 | 7 |  |  | 4 | 8 | 8 | 7 | 7 | 8
 |  |  |  |  | 5 | 6 | 6 | 7 | 6.5 | 6 |  |  | 5 | 1 | 1 | 1 | 1.5 | 2
 |  |  |  |  | 6 |  |  |  |  |  |  |  | 6
 |  |  |  |  | 7 |  |  |  |  |  |  |  | 7
 |  |  |  |  | 8 |  |  |  |  |  |  |  | 8
 |  |  |  |  | 9 |  |  |  |  |  |  |  | 9
 |  |  |  |  | 10 |  |  |  |  |  |  |  | 10
 |  |  |  |  | Round 4
 |  |  |  |  | Positions |  | Colors |  |  | Scores |  |  |  |  | Competitors Name
 |  |  |  |  | 1st
 |  |  |  |  | 2nd
 |  |  |  |  | 3rd
 |  |  |  |  | 4th
 |  |  |  |  |  |  |  | Yellow |  |  |  |  |  |  |  | Blue
 |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  | Heat Pts. |  |  |  |  |  |  |  | Heat Pts.
 |  |  |  |  | Wave Count | Judge 1 | Judge 2 | Judge 3 | Judge 4 | Judge 5 | [NAME] |  | Wave Count | Judge 1 | Judge 2 | Judge 3 | Judge 4 | Judge 5 | [NAME]
 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 |  |  | 1 | 10 | 10 | 10 | 10 | 10
 |  |  |  |  | 2 | 5 | 5 | 6 | 6.5 | 4.5 |  |  | 2 | 1 | 1 | 2 | 1 | 1
 |  |  |  |  | 3 | 4.5 | 5.5 | 4.8 | 6.3 | 5.5 |  |  | 3 | 5.5 | 5 | 5 | 5 | 6
 |  |  |  |  | 4 | 7.5 | 8 | 8 | 7.8 | 7.5 |  |  | 4
 |  |  |  |  | 5 | 1 | 2 | 2 | 1 | 1 |  |  | 5
 |  |  |  |  | 6 | 1 | 2 | 1 | 1 | 1 |  |  | 6
 |  |  |  |  | 7 |  |  |  |  |  |  |  | 7
 |  |  |  |  | 8 |  |  |  |  |  |  |  | 8
 |  |  |  |  | 9 |  |  |  |  |  |  |  | 9
 |  |  |  |  | 10 |  |  |  |  |  |  |  | 10
 |  |  |  |  |  |  |  | Green |  |  |  |  |  |  |  | White
 |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  | Heat Pts. |  |  |  |  |  |  |  | Heat Pts.
 |  |  |  |  | Wave Count | Judge 1 | Judge 2 | Judge 3 | Judge 4 | Judge 5 | [NAME] |  | Wave Count | Judge 1 | Judge 2 | Judge 3 | Judge 4 | Judge 5 | [NAME]
 |  |  |  |  | 1 | 2 | 2.5 | 3 | 2.5 | 3 |  |  | 1 | 6 | 7 | 6 | 6.5 | 7
 |  |  |  |  | 2 | 4 | 5 | 5 | 6 | 4.5 |  |  | 2 | 4.5 | 4.5 | 5.5 | 5 | 4.8
 |  |  |  |  | 3 | 1 | 2 | 1 | 1 | 1 |  |  | 3 | 4 | 5.5 | 3.8 | 5.5 | 5.5
 |  |  |  |  | 4 | 7.2 | 6.5 | 6.8 | 6 | 7 |  |  | 4 | 8 | 8 | 7 | 7 | 8
 |  |  |  |  | 5 | 6 | 6 | 7 | 6.5 | 6 |  |  | 5 | 1 | 1 | 1 | 1.5 | 2
 |  |  |  |  | 6 |  |  |  |  |  |  |  | 6
 |  |  |  |  | 7 |  |  |  |  |  |  |  | 7
 |  |  |  |  | 8 |  |  |  |  |  |  |  | 8
 |  |  |  |  | 9 |  |  |  |  |  |  |  | 9
 |  |  |  |  | 10 |  |  |  |  |  |  |  | 10