Spreadsheet: 128909d1321344501-countif-with-different-names-test-1-
Sheet: Sheet1

Rank | Time | IPS | Meet | Type | Athlete | YOB | Ctry | Season
MEN |  |  |  |  |  |  |  |  |  |  | Solution1 | Solution2
50 METRES FREESTYLE |  |  |  |  |  |  |  |  |  |  | [NAME] | Sumproduct
1 | 21.69 | 964 | WORLD05 | F | Schoeman,Roland | 1980 | RSA | LCM2005 |  | [NAME],[NAME]
2 | 21.89 | 951 | WORLD05 | F | Draganja,[NAME] | 1983 | CRO | LCM2005 |  | [NAME],[NAME]
3 | 21.94 | 947 | WORLD05 | F | [NAME],[NAME] | 1977 | POL | LCM2005 |  | Tutty,[NAME]
4 | 22.12 | 935 | GBRLCAUG | F | [NAME],[NAME] | 1983 | GBR | LCM2005 |  | Cozens,[NAME]
5 | 22.13 | 935 | USNATAUG | F | Wildman-Tobriner,[NAME] | 1984 | USA | LCM2005 |  | Morgan,[NAME]
6 | 22.13 | 935 | USOPNDEC | F | [NAME],[NAME] | 1981 | USA | LCM2005 |  | Houston,[NAME]
7 | 22.14 | 934 | WORLD05 | S | Iles,Salim | 1975 | ALG | LCM2005 |  | Barrack,[NAME]
8 | 22.14 | 934 | DEBICMAY | F | Gasior,Lukasz | 1986 | POL | LCM2005
9 | 22.16 | 933 | WORLD05 | F | Kapralov,[NAME] | 1980 | RUS | LCM2005 |  | Total
10 | 22.17 | 932 | FISUAUG | H | Jones,Cullen | 1984 | USA | LCM2005
11 | 22.19 | 930 | WORLD05 | S | Lorente,Eduardo | 1977 | ESP | LCM2005
12 | 22.21 | 929 | WORLD05 | H | [NAME],[NAME] | 1981 | FRA | LCM2005
13 | 22.23 | 928 | DUELAUG | F | Lezak,[NAME] | 1975 | USA | LCM2005
14 | 22.24 | 927 | [NAME] | F | [NAME],Javier | 1980 | ESP | LCM2005
15 | 22.26 | 926 | EURJRJUL | F | Deibler,Steffen | 1987 | GER | LCM2005
16 | 22.31 | 922 | WORLD05 | H | Sicot,Julien | 1978 | FRA | LCM2005
17 | 22.35 | 920 | WORLD05 | S | Volynets,[NAME] | 1974 | UKR | LCM2005
18 | 22.35 | 920 | AUSLCMAR | F | [NAME],[NAME] | 1975 | AUS | LCM2005
19 | 22.37 | 918 | BERLNMAR | H | El-Masri,[NAME] | 1982 | GER | LCM2005
20 | 22.42 | 915 | ITALCAPR | F | Vismara,Lorenzo | 1975 | ITA | LCM2005
21 | 22.44 | 914 | [NAME] | F | Weber-Gale,Garrett | 1985 | USA | LCM2005
22 | 22.44 | 914 | FISUAUG | F | Santos,[NAME] | 1980 | BRA | LCM2005
23 | 22.44 | 914 | WASADEC | F | [NAME],[NAME] | 1970 | GBR | LCM2005
24 | 22.44 | 914 | WORLD05 | S | Nystrand,[NAME] | 1981 | SWE | LCM2005
25 | 22.50 | 910 | CANETJUN | F | Maitre,[NAME] | 1980 | FRA | LCM2005
26 | 22.51 | 909 | WORLD05 | X | Veens,[NAME] | 1978 | NED | LCM2005
27 | 22.51 | 909 | WORLD05 | H | Mankoc,[NAME] | 1978 | SLO | LCM2005
28 | 22.55 | 906 | CANLCNOV | F | Hayden,Brent | 1982 | CAN | LCM2005
29 | 22.56 | 906 | WORLD05 | H | Lagunov,Evgeny | 1985 | RUS | LCM2005
30 | 22.59 | 904 | NSWDEC | F | Sullivan,Eamon | 1985 | AUS | LCM2005
31 | 22.61 | 902 | ARGLCDEC | F | Meolans,[NAME] | 1978 | ARG | LCM2005
32 | 22.63 | 901 | ITALCAPR | H | Scarica,[NAME] | 1982 | ITA | LCM2005
33 | 22.65 | 900 | TXSRJUL | H | Walker,[NAME] | 1976 | USA | LCM2005
34 | 22.67 | 898 | NEDLCAPR | F | [NAME],[NAME] | 1980 | NED | LCM2005
35 | 22.68 | 897 | WORLD05 | H | Neethling,Ryk | 1977 | RSA | LCM2005
36 | 22.69 | 897 | VCUP6MAR | F | Bernard,Alain | 1983 | FRA | LCM2005
37 | 22.69 | 897 | [NAME] | F | Dehmlow,Carsten | 1977 | GER | LCM2005
38 | 22.70 | 896 | MVNJUN | F | Ferns,Lyndon | 1983 | RSA | LCM2005
39 | 22.70 | 896 | CACLBJUL | F | Rose,[NAME] | 1981 | CAN | LCM2005
40 | 22.71 | 895 | WORLD05 | H | Rajakyla,Matti | 1984 | FIN | LCM2005
41 | 22.71 | 895 | QLDDEC | F | Callus,[NAME] | 1979 | AUS | LCM2005
42 | 22.71 | 895 | RUSLCMAR | F | Khokhlov,[NAME] | 1980 | RUS | LCM2005
43 | 22.71 | 895 | [NAME] | F | [NAME],[NAME] | 1983 | GER | LCM2005
44 | 22.71 | 895 | ALMERJUN | F | [NAME],[NAME] | 1986 | SLO | LCM2005
45 | 22.74 | 893 | AUSLCMAR | F | English,[NAME] | 1978 | AUS | LCM2005
46 | 22.74 | 893 | DUELAUG | F | [NAME],[NAME] | 1977 | AUS | LCM2005
47 | 22.77 | 891 | FISUAUG | F | Novy,[NAME] | 1980 | SUI | LCM2005
48 | 22.77 | 891 | GBRLCMAR | F | Tutty,[NAME] | 1984 | GBR | LCM2005
49 | 22.78 | 891 | FRALCAPR | F | Gilot,Fabien | 1984 | FRA | LCM2005
50 | 22.78 | 891 | GBRLCAUG | F | Cozens,[NAME] | 1982 | GBR | LCM2005
51 | 22.79 | 890 | WORLD05 | H | Gimbutis,Rolandas | 1981 | LTU | LCM2005
52 | 22.79 | 890 | ITALCAPR | F | Vassanelli,Giacomo | 1983 | ITA | LCM2005
53 | 22.80 | 889 | [NAME] | F | [NAME],[NAME] | 1983 | USA | LCM2005
54 | 22.81 | 889 | WORLD05 | H | Scherer,[NAME] | 1974 | BRA | LCM2005
55 | 22.85 | 886 | EASIANOV | F | [NAME],[NAME] | 1987 | CHN | LCM2005
56 | 22.86 | 885 | CHNOCT | S | [NAME],Lifeng | 1978 | CHN | LCM2005
57 | 22.86 | 885 | [NAME] | F | [NAME],[NAME] | 1976 | GER | LCM2005
58 | 22.89 | 883 | ITALCAPR | F | [NAME],Alessandro | 1983 | ITA | LCM2005
59 | 22.90 | 883 | USNATAUG | F | Goodrich,[NAME] | 1986 | USA | LCM2005
60 | 22.91 | 882 | CANLCMAY | F | [NAME],[NAME] | 1980 | CAN | LCM2005
61 | 22.92 | 881 | AUSLCMAR | H | [NAME],[NAME] | 1986 | AUS | LCM2005
62 | 22.92 | 881 | BRALCMAY | H | [NAME],[NAME] | 1987 | BRA | LCM2005
63 | 22.92 | 881 | FISUAUG | H | Tayla,Kaan | 1986 | TUR | LCM2005
64 | 22.94 | 880 | [NAME] | F | Ito,Makoto | 1986 | JPN | LCM2005
65 | 22.96 | 879 | ITTMAJUN | F | Magnini,Filippo | 1982 | ITA | LCM2005
66 | 22.96 | 879 | AUSLCMAR | H | Laforest,[NAME] | 1983 | AUS | LCM2005
67 | 22.96 | 879 | WORLD05 | H | Busquets,Ricardo | 1975 | PUR | LCM2005
68 | 22.96 | 879 | USNATAUG | H | Nelms,[NAME] | 1985 | USA | LCM2005
69 | 22.96 | 879 | BRISBMAR | F | Piper,Sean | 1982 | AUS | LCM2005
70 | 22.97 | 878 | WORLD05 | H | Pihl,Marcus | 1985 | SWE | LCM2005
71 | 22.98 | 877 | SEADEC | F | Chinnapasaen,Arwut | 1980 | THA | LCM2005
72 | 22.99 | 877 | WORLD05 | H | Neviarovski,Stanislav | 1981 | BLR | LCM2005
73 | 22.99 | 877 | NSWDEC | F | Newton,Jonathon | 1981 | AUS | LCM2005
74 | 23.00 | 876 | ITALCAPR | F | Bocchia,[NAME] | 1986 | ITA | LCM2005
75 | 23.00 | 876 | USOPNDEC | F | Townsend,Darian | 1984 | RSA | LCM2005
76 | 23.01 | 875 | IRVINMAY | B | Cavic,Milorad | 1984 | SRB | LCM2005
77 | 23.02 | 875 | EURJRJUL | F | Belov,[NAME] | 1987 | UKR | LCM2005
78 | 23.02 | 875 | CHNOCT | F | [NAME],[NAME] | 1979 | CHN | LCM2005
79 | 23.03 | 874 | ITALCAUG | F | Galenda,Christian | 1982 | ITA | LCM2005
80 | 23.03 | 874 | MINCHJUL | F | Grevers,[NAME] | 1985 | USA | LCM2005
81 | 23.04 | 873 | CHNOCT | S | [NAME],Jiawei | 1983 | CHN | LCM2005
82 | 23.04 | 873 | USNATAUG | H | Hollinger,Cameron | 1985 | USA | LCM2005
83 | 23.04 | 873 | VCUP3FEB | F | Barnier,Romain | 1976 | FRA | LCM2005
84 | 23.04 | 873 | EINDHMAR | F | Damen,Gijs | 1979 | NED | LCM2005
85 | 23.06 | 872 | OKAYASEP | F | Yamamoto,Hiroaki | 1987 | JPN | LCM2005
86 | 23.06 | 872 | WASADEC | F | Morgan,[NAME] | 1984 | GBR | LCM2005
87 | 23.07 | 871 | BRALCMAY | F | Oliveira,[NAME] | 1980 | BRA | LCM2005
88 | 23.07 | 871 | AUSLCMAR | S | [NAME],[NAME] | 1978 | AUS | LCM2005
89 | 23.07 | 871 | [NAME] | H | [NAME],[NAME] | 1979 | USA | LCM2005
90 | 23.08 | 871 | USOPNDEC | B | Targett,[NAME] | 1985 | AUS | LCM2005
91 | 23.09 | 870 | DEBICMAY | F | [NAME],[NAME] | 1984 | POL | LCM2005
92 | 23.10 | 869 | USNATAUG | B | Zandberg,Gerhard | 1983 | RSA | LCM2005
93 | 23.10 | 869 | JPNLCAPR | F | Hosokawa,Daisuke | 1982 | JPN | LCM2005
94 | 23.11 | 869 | FISUAUG | B | Yegoshin,Yuriy | 1985 | UKR | LCM2005
95 | 23.11 | 869 | [NAME] | H | Schreiber,[NAME] | 1982 | GER | LCM2005
96 | 23.11 | 869 | USNATAUG | H | Alesi,Octavio | 1986 | VEN | LCM2005
97 | 23.11 | 869 | USNATAUG | H | [NAME],[NAME] | 1986 | USA | LCM2005
98 | 23.11 | 869 | EURJRJUL | F | Venancio,Tiago | 1987 | POR | LCM2005
99 | 23.11 | 869 | GBRLCAUG | F | Houston,[NAME] | 1985 | GBR | LCM2005
100 | 23.12 | 868 | RUSLCJUN | F | [NAME],[NAME] | 1980 | RUS | LCM2005
101 | 23.12 | 868 | CHNOCT | F | Han,Tianji | 1982 | CHN | LCM2005
102 | 23.13 | 867 | TXSRJUL | H | Crocker,[NAME] | 1982 | USA | LCM2005
103 | 23.13 | 867 | [NAME] | H | Santana,[NAME] | 1982 | ESP | LCM2005
104 | 23.13 | 867 | ITALCAPR | H | Addamiano,Fabrizio | 1985 | ITA | LCM2005
105 | 23.13 | 867 | [NAME] | F | Shyrshov,[NAME] | 1979 | UKR | LCM2005
106 | 23.13 | 867 | GBRLCAUG | F | [NAME],[NAME] | 1979 | GBR | LCM2005
107 | 23.14 | 867 | ROMAJUN | H | di Carli,[NAME] | 1985 | GER | LCM2005
108 | 23.14 | 867 | SCSCJUN | H | Tilly,[NAME] | 1984 | SWE | LCM2005
109 | 23.14 | 867 | ITALCAPR | H | Savino,[NAME] | 1984 | ITA | LCM2005
110 | 23.15 | 866 | ITALCAUG | S | Gusperti,[NAME] | 1971 | ITA | LCM2005
111 | 23.15 | 866 | FISUAUG | H | Deboni,Eduardo | 1981 | BRA | LCM2005
112 | 23.15 | 866 | ALMERJUN | F | Papachrysanthu,[NAME] | 1979 | CYP | LCM2005
113 | 23.16 | 865 | CHNOCT | S | Du,Yingzhe | 1984 | CHN | LCM2005
114 | 23.16 | 865 | BRALCMAY | F | Santos,Cristiano | 1980 | BRA | LCM2005
115 | 23.16 | 865 | EASIANOV | F | Koga,[NAME] | 1987 | JPN | LCM2005
116 | 23.16 | 865 | [NAME] | F | Sasaki,Takeru | 1985 | JPN | LCM2005
117 | 23.17 | 865 | [NAME] | B | [NAME],[NAME] | 1985 | USA | LCM2005
118 | 23.17 | 865 | AKROPMAY | H | Tsoltos,[NAME] | 1979 | GRE | LCM2005
119 | 23.17 | 865 | OKAYASEP | F | Takeuchi,Naoki | 1982 | JPN | LCM2005
120 | 23.17 | 865 | CHNLCAPR | F | [NAME],[NAME] | 1982 | CHN | LCM2005
121 | 23.17 | 865 | HANVRAPR | F | Kunzelmann,Stephan | 1978 | GER | LCM2005
122 | 23.18 | 864 | [NAME] | B | Goodrich,[NAME] | 1986 | USA | LCM2005
123 | 23.18 | 864 | AKROPMAY | F | Tsagkarakis,[NAME] | 1982 | GRE | LCM2005
124 | 23.19 | 863 | ITALCAPR | H | Dinia,Vittorio | 1986 | ITA | LCM2005
125 | 23.19 | 863 | BRALCMAY | H | Santos,Guilherme | 1982 | BRA | LCM2005
126 | 23.19 | 863 | [NAME] | F | vom Scheidt,[NAME] | 1986 | GER | LCM2005
127 | 23.19 | 863 | ITTMAJUN | F | Chinellato,Alessandro | 1986 | ITA | LCM2005
128 | 23.19 | 863 | ESPLCAUG | F | Urtasun,Javier | 1980 | ESP | LCM2005
129 | 23.21 | 862 | FRALCAPR | H | [NAME],Germain | 1983 | FRA | LCM2005
130 | 23.21 | 862 | USNATAUG | B | [NAME],[NAME] | 1979 | USA | LCM2005
131 | 23.22 | 861 | [NAME] | F | Kawachi,[NAME] | 1986 | JPN | LCM2005
132 | 23.22 | 861 | ARGLCDEC | F | Aguilera,[NAME] | 1985 | ARG | LCM2005
133 | 23.23 | 861 | BERLNMAR | F | Grosse,Sven | 1977 | GER | LCM2005
134 | 23.24 | 860 | GBRLCMAR | S | Clay,[NAME] | 1982 | GBR | LCM2005
135 | 23.24 | 860 | EINDHMAR | H | Oosting,[NAME] | 1981 | NED | LCM2005
136 | 23.24 | 860 | CANLCMAY | F | Janes,Riley | 1980 | CAN | LCM2005
137 | 23.24 | 860 | RUSLCJUN | F | [NAME],[NAME] | 1984 | RUS | LCM2005
138 | 23.24 | 860 | SFGENFEB | F | Leveaux,Amaury | 1985 | FRA | LCM2005
139 | 23.25 | 859 | ROMAJUN | B | Deriu,Pietro | 1981 | ITA | LCM2005
140 | 23.25 | 859 | GBRLCAUG | H | Scotcher,[NAME] | 1980 | GBR | LCM2005
141 | 23.26 | 859 | ITALCAUG | S | Gallo,Mauro | 1979 | ITA | LCM2005
142 | 23.26 | 859 | ALMERJUN | H | [NAME],[NAME] | 1985 | GRE | LCM2005
143 | 23.27 | 858 | [NAME] | H | Wochomurka,[NAME] | 1984 | USA | LCM2005
144 | 23.27 | 858 | CHNOCT | F | Shi,Runqiang | 1988 | CHN | LCM2005
145 | 23.28 | 857 | CANETJUN | B | Thaning,[NAME] | 1978 | RSA | LCM2005
146 | 23.28 | 857 | NEDLCAPR | F | [NAME],[NAME] | 1985 | NED | LCM2005
147 | 23.28 | 857 | [NAME] | F | Kishida,Masayuki | 1985 | JPN | LCM2005
148 | 23.29 | 857 | BRALCMAY | F | Sapucaia,[NAME] | 1983 | BRA | LCM2005
149 | 23.29 | 857 | AUBRNJUL | F | Farnham,[NAME] | 1983 | USA | LCM2005
150 | 23.29 | 857 | CANLCNOV | F | [NAME],[NAME] | 1984 | CAN | LCM2005