Spreadsheet: 797729d1664108193-formula-for-finding-and-matching-values-2022-09-25-oeldere-xlhell-problem-test-sheet-1-
Sheet: Tabel1

nr | Game ID | IT | Value
74266 | RG Sharma | ipl910 | 0 |  |  |  |  | Rijlabels | Sum Value | Averge Value2
74266 | RG Sharma | itt1133 | 15 |  |  |  |  | AT Rayudu | 40 | 40
74266 | RG Sharma | itt1135 | 12 |  |  |  |  | Babar Azam | 126 | 25.2
1377783 | IP Kishan | ipl910 | 0 |  |  |  |  | D Pretorius | 46 | 11.5
1377783 | IP Kishan | itt1132 | 56 |  |  |  |  | DJ Bravo | 7 | 1.75
1377783 | IP Kishan | itt1133 | 4 |  |  |  |  | [NAME] | 59 | 11.8
2437039 | [NAME] | ipl910 | 4 |  |  |  |  | [NAME] | 4 | 4
264193 | SA Yadav | ipl910 | 32 |  |  |  |  | [NAME] | 37 | 18.5
264193 | SA Yadav | itt1132 | 0 |  |  |  |  | H Shokeen | 25 | 25
264193 | SA Yadav | itt1135 | 57 |  |  |  |  | [NAME] | 122 | 17.42857142857143
1774169 | NT [NAME] | ipl910 | 51 |  |  |  |  | [NAME] | 0 | 0
2272567 | H Shokeen | ipl910 | 25 |  |  |  |  | [NAME] | 35 | 8.75
97647 | KA Pollard | ipl910 | 14 |  |  |  |  | IP Kishan | 60 | 20
97647 | KA Pollard | itt1108 | 75 |  |  |  |  | [NAME] | 19 | 19
97647 | KA Pollard | itt1110 | 28 |  |  |  |  | JJ [NAME] | 0 | 0
97647 | KA Pollard | itt1126 | 38 |  |  |  |  | KA Pollard | 168 | 28
97647 | KA Pollard | itt1128 | 13 |  |  |  |  | MG Choudhary | 0 | 0
97647 | KA Pollard | itt1130 | 0 |  |  |  |  | [NAME] | 64 | 8
1230394 | [NAME] | ipl910 | 5 |  |  |  |  | MM Theekshana | 0 | 0
1230394 | [NAME] | itt1115 | 8 |  |  |  |  | [NAME] | 295 | 59
1230394 | [NAME] | itt1116 | 4 |  |  |  |  | [NAME] | 28 | 28
1230394 | [NAME] | itt1123 | 1 |  |  |  |  | NT [NAME] | 51 | 51
1230394 | [NAME] | itt1124 | 41 |  |  |  |  | [NAME] | 47 | 23.5
264173 | [NAME] | ipl910 | 19 |  |  |  |  | [NAME] | 0 | 0
1381886 | RP Meredith | ipl910 | 0 |  |  |  |  | RG Sharma | 27 | 9
1381886 | RP Meredith | itt1125 | 0 |  |  |  |  | RP Meredith | 0 | 0
1381886 | RP Meredith | [NAME] | 0 |  |  |  |  | RV Uthappa | 30 | 30
1381886 | RP Meredith | itt1129 | 0 |  |  |  |  | SA Yadav | 89 | 29.66666666666667
1196767 | JJ [NAME] | ipl910 | 0 |  |  |  |  | [NAME] | 0 | 0
1358247 | [NAME] | ipl910 | 0 |  |  |  |  | [NAME] | 61 | 12.2
8681 | RV Uthappa | ipl910 | 30 |  |  |  |  | [NAME] | 10 | 1.25
952567 | [NAME] | ipl910 | 11 |  |  |  |  | [NAME] | 14 | 7
952567 | [NAME] | itt1108 | 31 |  |  |  |  | SR Dubey | 13 | 13
952567 | [NAME] | itt1110 | 0 |  |  |  |  | [NAME] | 9 | 3
952567 | [NAME] | itt1117 | 12 |  |  |  |  | Eindtotaal | 1486 | 14.42718446601942
952567 | [NAME] | itt1123 | 7
952567 | [NAME] | itt1124 | 0
952567 | [NAME] | [NAME] | 3
952567 | [NAME] | itt1129 | 0
8931 | AT Rayudu | ipl910 | 40
1917128 | SR Dubey | ipl910 | 13
94280 | [NAME] | ipl910 | 3
94280 | [NAME] | itt1114 | 44
7561 | [NAME] | ipl910 | 28
247668 | D Pretorius | ipl910 | 22
247668 | D Pretorius | itt1120 | 15
247668 | D Pretorius | itt1121 | 0
247668 | D Pretorius | itt1122 | 9
44613 | DJ Bravo | ipl910 | 1
44613 | DJ Bravo | itt1126 | 4
44613 | DJ Bravo | itt1128 | 2
44613 | DJ Bravo | itt1130 | 0
2206768 | MM Theekshana | ipl910 | 0
2266673 | MG Choudhary | ipl910 | 0
166944 | Babar Azam | itt1094 | 21
166944 | Babar Azam | itt1093 | 56
166944 | Babar Azam | itt1120 | 0
166944 | Babar Azam | itt1121 | 5
166944 | Babar Azam | itt1122 | 44
251815 | [NAME] | itt1094 | 1
251815 | [NAME] | itt1093 | 36
2053717 | [NAME] | itt1094 | 54
2053717 | [NAME] | itt1117 | 3
2053717 | [NAME] | [NAME] | 8
2053717 | [NAME] | itt1119 | 11
2053717 | [NAME] | itt1120 | 21
2053717 | [NAME] | itt1121 | 10
2053717 | [NAME] | itt1122 | 15
19345 | [NAME] | itt1094 | 86
19345 | [NAME] | itt1093 | 69
19345 | [NAME] | itt1117 | 0
19345 | [NAME] | [NAME] | 99
19345 | [NAME] | itt1119 | 41
1913878 | [NAME] | itt1094 | 15
1913878 | [NAME] | itt1093 | 0
1913878 | [NAME] | itt1117 | 42
1913878 | [NAME] | [NAME] | 4
1913878 | [NAME] | itt1119 | 0
80441 | [NAME] | itt1094 | 6
80441 | [NAME] | itt1093 | 0
80441 | [NAME] | itt1117 | 19
80441 | [NAME] | [NAME] | 10
8219 | [NAME] | itt1094 | 0
8219 | [NAME] | itt1093 | 14
69226 | [NAME] | itt1094 | 0
24381 | [NAME] | itt1094 | 0
24381 | [NAME] | itt1117 | 9
24381 | [NAME] | [NAME] | 0
2248308 | [NAME] | itt1094 | 0
2248308 | [NAME] | itt1093 | 0
2248308 | [NAME] | itt1117 | 0
2248308 | [NAME] | [NAME] | 0
2248308 | [NAME] | itt1119 | 0
2248308 | [NAME] | itt1120 | 0
2248308 | [NAME] | itt1121 | 0
2128597 | [NAME] | itt1094 | 0
2128597 | [NAME] | itt1093 | 0
2128597 | [NAME] | itt1117 | 10
2128597 | [NAME] | [NAME] | 0
2128597 | [NAME] | itt1119 | 0
2128597 | [NAME] | itt1120 | 0
2128597 | [NAME] | itt1121 | 0
2128597 | [NAME] | itt1122 | 0