Hello To All,</SPAN></SPAN>
I want to check the result database, which is given in the example below in cells Y2:AL13 with my played combinations is given in the cells B2:O13 </SPAN></SPAN>
And I want to have counted only that row combination that has minimum 10 to 14 is correct. </SPAN></SPAN>
<TBODY>
</TBODY>
<TBODY>
</TBODY>
Here the below is a final count of all result. Which I have calculated manually.</SPAN></SPAN>
<TBODY>
</TBODY>Please is it possible to get VBA solution for this problem.</SPAN></SPAN>
Regards,</SPAN></SPAN>
Kishan</SPAN></SPAN>
I want to check the result database, which is given in the example below in cells Y2:AL13 with my played combinations is given in the cells B2:O13 </SPAN></SPAN>
And I want to have counted only that row combination that has minimum 10 to 14 is correct. </SPAN></SPAN>
| A</SPAN></SPAN> | B</SPAN></SPAN> | C</SPAN></SPAN> | D</SPAN></SPAN> | E</SPAN></SPAN> | F</SPAN></SPAN> | G</SPAN></SPAN> | H</SPAN></SPAN> | I</SPAN></SPAN> | J</SPAN></SPAN> | K</SPAN></SPAN> | L</SPAN></SPAN> | M</SPAN></SPAN> | N</SPAN></SPAN> | O</SPAN></SPAN> | P</SPAN></SPAN> | Q</SPAN></SPAN> | R</SPAN></SPAN> | S</SPAN></SPAN> | T</SPAN></SPAN> | U</SPAN></SPAN> | V</SPAN></SPAN> | W</SPAN></SPAN> | X</SPAN></SPAN> | Y</SPAN></SPAN> | Z</SPAN></SPAN> | AA</SPAN></SPAN> | AB</SPAN></SPAN> | AC</SPAN></SPAN> | AD</SPAN></SPAN> | AE</SPAN></SPAN> | AF</SPAN></SPAN> | AG</SPAN></SPAN> | AH</SPAN></SPAN> | AI</SPAN></SPAN> | AJ</SPAN></SPAN> | AK</SPAN></SPAN> | AL</SPAN></SPAN> |
1</SPAN></SPAN> | Nº Comb</SPAN></SPAN> | P1</SPAN></SPAN> | P2</SPAN></SPAN> | P3</SPAN></SPAN> | P4</SPAN></SPAN> | P5</SPAN></SPAN> | P6</SPAN></SPAN> | P7</SPAN></SPAN> | P8</SPAN></SPAN> | P9</SPAN></SPAN> | P10</SPAN></SPAN> | P11</SPAN></SPAN> | P12</SPAN></SPAN> | P13</SPAN></SPAN> | P14</SPAN></SPAN> | | Result</SPAN> | | 10</SPAN> | 11</SPAN> | 12</SPAN> | 13</SPAN> | 14</SPAN> | Draws nº</SPAN></SPAN> | P1</SPAN></SPAN> | P2</SPAN></SPAN> | P3</SPAN></SPAN> | P4</SPAN></SPAN> | P5</SPAN></SPAN> | P6</SPAN></SPAN> | P7</SPAN></SPAN> | P8</SPAN></SPAN> | P9</SPAN></SPAN> | P10</SPAN></SPAN> | P11</SPAN></SPAN> | P12</SPAN></SPAN> | P13</SPAN></SPAN> | P14</SPAN></SPAN> |
2</SPAN></SPAN> | 1</SPAN></SPAN> | X</SPAN> | 1</SPAN> | X</SPAN> | 1</SPAN> | 1</SPAN></SPAN> | 1</SPAN> | X</SPAN> | 1</SPAN></SPAN> | X</SPAN></SPAN> | 1</SPAN></SPAN> | 1</SPAN> | 2</SPAN> | 1</SPAN> | 1</SPAN> | | 10</SPAN> | | 1</SPAN></SPAN> | | | | | 1</SPAN></SPAN> | X</SPAN> | 1</SPAN> | X</SPAN> | 1</SPAN> | X</SPAN> | 1</SPAN> | X</SPAN> | X</SPAN> | 1</SPAN> | X</SPAN> | 1</SPAN> | 2</SPAN> | 1</SPAN> | 1</SPAN> |
3</SPAN></SPAN> | 2</SPAN></SPAN> | X</SPAN> | X</SPAN></SPAN> | X</SPAN> | 1</SPAN> | X</SPAN> | 1</SPAN> | X</SPAN> | 1</SPAN></SPAN> | 1</SPAN> | 1</SPAN></SPAN> | 1</SPAN> | 1</SPAN></SPAN> | 1</SPAN> | 1</SPAN> | | 10</SPAN> | | 1</SPAN></SPAN> | | | | | 2</SPAN></SPAN> | 2</SPAN> | 2</SPAN> | 2</SPAN> | 2</SPAN> | 2</SPAN> | X</SPAN> | X</SPAN> | X</SPAN> | 2</SPAN> | 1</SPAN> | X</SPAN> | X</SPAN> | 2</SPAN> | 1</SPAN> |
4</SPAN></SPAN> | 3</SPAN></SPAN> | 1</SPAN></SPAN> | 1</SPAN> | X</SPAN> | 1</SPAN> | 2</SPAN></SPAN> | 1</SPAN> | X</SPAN> | X</SPAN> | 1</SPAN> | X</SPAN> | 1</SPAN> | 1</SPAN></SPAN> | 1</SPAN> | 2</SPAN></SPAN> | | 10</SPAN> | | 1</SPAN></SPAN> | | | | | 3</SPAN></SPAN> | 1</SPAN> | X</SPAN> | 1</SPAN> | 1</SPAN> | 1</SPAN> | X</SPAN> | 2</SPAN> | 1</SPAN> | 1</SPAN> | 2</SPAN> | 1</SPAN> | 1</SPAN> | X</SPAN> | X</SPAN> |
5</SPAN></SPAN> | 4</SPAN></SPAN> | X</SPAN> | 2</SPAN></SPAN> | X</SPAN> | 1</SPAN> | 1</SPAN></SPAN> | 2</SPAN></SPAN> | X</SPAN> | 1</SPAN></SPAN> | 1</SPAN> | X</SPAN> | 1</SPAN> | 2</SPAN> | 1</SPAN> | 1</SPAN> | | 10</SPAN> | | 1</SPAN></SPAN> | | | | | 4</SPAN></SPAN> | 2</SPAN> | 2</SPAN> | X</SPAN> | 1</SPAN> | 1</SPAN> | X</SPAN> | X</SPAN> | 2</SPAN> | 1</SPAN> | 1</SPAN> | X</SPAN> | X</SPAN> | X</SPAN> | 2</SPAN> |
6</SPAN></SPAN> | 5</SPAN></SPAN> | X</SPAN> | 1</SPAN> | X</SPAN> | 1</SPAN> | X</SPAN> | 1</SPAN> | 2</SPAN></SPAN> | 1</SPAN></SPAN> | 1</SPAN> | X</SPAN> | 2</SPAN></SPAN> | 2</SPAN> | 2</SPAN></SPAN> | 1</SPAN> | | 10</SPAN> | | 1</SPAN></SPAN> | | | | | 5</SPAN></SPAN> | 2</SPAN> | X</SPAN> | 1</SPAN> | 1</SPAN> | 1</SPAN> | 1</SPAN> | X</SPAN> | 2</SPAN> | X</SPAN> | 1</SPAN> | X</SPAN> | X</SPAN> | 2</SPAN> | 2</SPAN> |
7</SPAN></SPAN> | 6</SPAN></SPAN> | X</SPAN> | 1</SPAN> | X</SPAN> | 1</SPAN> | X</SPAN> | 2</SPAN></SPAN> | X</SPAN> | X</SPAN> | 1</SPAN> | 1</SPAN></SPAN> | X</SPAN></SPAN> | X</SPAN></SPAN> | 1</SPAN> | 1</SPAN> | | 10</SPAN> | | 1</SPAN></SPAN> | | | | | 6</SPAN></SPAN> | X</SPAN> | 1</SPAN> | 1</SPAN> | X</SPAN> | 1</SPAN> | 2</SPAN> | 1</SPAN> | 2</SPAN> | 2</SPAN> | 2</SPAN> | 1</SPAN> | 1</SPAN> | 2</SPAN> | 2</SPAN> |
8</SPAN></SPAN> | 7</SPAN></SPAN> | 1</SPAN></SPAN> | 2</SPAN></SPAN> | 2</SPAN></SPAN> | X</SPAN></SPAN> | 2</SPAN></SPAN> | X</SPAN></SPAN> | 1</SPAN></SPAN> | X</SPAN> | 2</SPAN></SPAN> | 1</SPAN></SPAN> | X</SPAN></SPAN> | X</SPAN></SPAN> | 2</SPAN></SPAN> | X</SPAN></SPAN> | | 1</SPAN></SPAN> | | | | | | | 7</SPAN></SPAN> | 1</SPAN> | 1</SPAN> | 2</SPAN> | 1</SPAN> | 1</SPAN> | 1</SPAN> | X</SPAN> | 1</SPAN> | 1</SPAN> | 1</SPAN> | X</SPAN> | 1</SPAN> | 2</SPAN> | 1</SPAN> |
9</SPAN></SPAN> | 8</SPAN></SPAN> | 2</SPAN></SPAN> | 2</SPAN></SPAN> | 2</SPAN></SPAN> | X</SPAN></SPAN> | X</SPAN> | 2</SPAN></SPAN> | X</SPAN> | X</SPAN> | 2</SPAN></SPAN> | 1</SPAN></SPAN> | X</SPAN></SPAN> | X</SPAN></SPAN> | 2</SPAN></SPAN> | 1</SPAN> | | 4</SPAN></SPAN> | | | | | | | 8</SPAN></SPAN> | 1</SPAN> | 1</SPAN> | 1</SPAN> | X</SPAN> | 1</SPAN> | X</SPAN> | 1</SPAN> | 2</SPAN> | 2</SPAN> | 1</SPAN> | X</SPAN> | X</SPAN> | 1</SPAN> | X</SPAN> |
10</SPAN></SPAN> | 9</SPAN></SPAN> | 2</SPAN></SPAN> | 2</SPAN></SPAN> | 1</SPAN></SPAN> | 2</SPAN></SPAN> | 2</SPAN></SPAN> | 2</SPAN></SPAN> | X</SPAN> | 2</SPAN></SPAN> | 2</SPAN></SPAN> | 1</SPAN></SPAN> | X</SPAN></SPAN> | X</SPAN></SPAN> | 2</SPAN></SPAN> | 2</SPAN></SPAN> | | 1</SPAN></SPAN> | | | | | | | 9</SPAN></SPAN> | 1</SPAN> | X</SPAN> | X</SPAN> | 1</SPAN> | 2</SPAN> | 1</SPAN> | 1</SPAN> | 1</SPAN> | X</SPAN> | 2</SPAN> | 1</SPAN> | 1</SPAN> | X</SPAN> | 2</SPAN> |
11</SPAN></SPAN> | 10</SPAN></SPAN> | 2</SPAN></SPAN> | 2</SPAN></SPAN> | X</SPAN> | 2</SPAN></SPAN> | 2</SPAN></SPAN> | X</SPAN></SPAN> | X</SPAN> | X</SPAN> | X</SPAN></SPAN> | 1</SPAN></SPAN> | X</SPAN></SPAN> | X</SPAN></SPAN> | X</SPAN></SPAN> | 2</SPAN></SPAN> | | 3</SPAN></SPAN> | | | | | | | 10</SPAN></SPAN> | 1</SPAN> | X</SPAN> | 2</SPAN> | 1</SPAN> | 1</SPAN> | X</SPAN> | 1</SPAN> | 2</SPAN> | X</SPAN> | 2</SPAN> | 1</SPAN> | 1</SPAN> | X</SPAN> | 2</SPAN> |
12</SPAN></SPAN> | 11</SPAN></SPAN> | 1</SPAN></SPAN> | X</SPAN></SPAN> | 1</SPAN></SPAN> | 2</SPAN></SPAN> | 1</SPAN></SPAN> | 2</SPAN></SPAN> | X</SPAN> | 1</SPAN></SPAN> | 1</SPAN> | 2</SPAN></SPAN> | 1</SPAN> | 2</SPAN> | X</SPAN></SPAN> | X</SPAN></SPAN> | | 4</SPAN></SPAN> | | | | | | | 11</SPAN></SPAN> | X</SPAN> | 1</SPAN> | X</SPAN> | 1</SPAN> | 1</SPAN> | 1</SPAN> | 2</SPAN> | 1</SPAN> | 1</SPAN> | X</SPAN> | X</SPAN> | 2</SPAN> | X</SPAN> | X</SPAN> |
13</SPAN></SPAN> | 12</SPAN></SPAN> | 1</SPAN></SPAN> | 2</SPAN></SPAN> | 1</SPAN></SPAN> | 2</SPAN></SPAN> | 1</SPAN></SPAN> | X</SPAN></SPAN> | 2</SPAN></SPAN> | X</SPAN> | 1</SPAN> | 2</SPAN></SPAN> | 1</SPAN> | 1</SPAN></SPAN> | X</SPAN></SPAN> | 2</SPAN></SPAN> | | 3</SPAN></SPAN> | | | | | | | 12</SPAN></SPAN> | X</SPAN> | 1</SPAN> | 1</SPAN> | 1</SPAN> | 2</SPAN> | 1</SPAN> | 2</SPAN> | 1</SPAN> | 1</SPAN> | 2</SPAN> | 1</SPAN> | 2</SPAN> | X</SPAN> | 1</SPAN> |
<TBODY>
</TBODY>
Spreadsheet Formulas</SPAN> | ||||||||||||||||||||||||||
<TBODY> </TBODY> | ||||||||||||||||||||||||||
Formula Array:</SPAN> Produce enclosing { } by entering formula with CTRL+SHIFT+ENTER!</SPAN> |
<TBODY>
</TBODY>
Here the below is a final count of all result. Which I have calculated manually.</SPAN></SPAN>
| S</SPAN></SPAN> | T</SPAN></SPAN> | U</SPAN></SPAN> | V</SPAN></SPAN> | W</SPAN></SPAN> |
15</SPAN></SPAN> | 10</SPAN> | 11</SPAN> | 12</SPAN> | 13</SPAN> | 14</SPAN> |
16</SPAN></SPAN> | 1</SPAN></SPAN> | | | | |
17</SPAN></SPAN> | 1</SPAN></SPAN> | | | | |
18</SPAN></SPAN> | 1</SPAN></SPAN> | | | | |
19</SPAN></SPAN> | 1</SPAN></SPAN> | | | | |
20</SPAN></SPAN> | 2</SPAN></SPAN> | | | | |
21</SPAN></SPAN> | 1</SPAN></SPAN> | | | | |
22</SPAN></SPAN> | 1</SPAN></SPAN> | 1</SPAN></SPAN> | | | |
23</SPAN></SPAN> | | | | | |
24</SPAN></SPAN> | 1</SPAN></SPAN> | | | | |
25</SPAN></SPAN> | 2</SPAN></SPAN> | | | | |
26</SPAN></SPAN> | 1</SPAN></SPAN> | | | | |
27</SPAN></SPAN> | 1</SPAN></SPAN> | | | | |
<TBODY>
</TBODY>
Regards,</SPAN></SPAN>
Kishan</SPAN></SPAN>