Hi everyone,</SPAN></SPAN>
The below example I have all 1 I want to count 2 Diagonal and 3 Diagonal as shown</SPAN></SPAN>
Where I need to count diagonal right side of the upper rows and left side of the lower rows</SPAN></SPAN>
For example1: if we check in row 5 we have 3 diagonal with 2 match</SPAN> (first in cell E5=1 and cell F4=1) second in cell J5=1 and cell K4=1, and last (third in cell L5=1 and M4=1) </SPAN></SPAN>
For example1: if we check in row 6 we have </SPAN>3 diagonal with 2 match and 1 with 3 match</SPAN> (first in cell E7=1 and cell E6=1) second in cell F7=1 And cell G6=1, and 3 diagonal match are In cell F7=1, cell G6=1 and Cell E8=1</SPAN></SPAN>
<COLGROUP><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL></COLGROUP><THEAD>
</THEAD><TBODY>
</TBODY>
Results are shown in columns P And Q</SPAN></SPAN>
Please help</SPAN></SPAN>
Thanks And Regards,</SPAN></SPAN>
Moti</SPAN></SPAN>
The below example I have all 1 I want to count 2 Diagonal and 3 Diagonal as shown</SPAN></SPAN>
Where I need to count diagonal right side of the upper rows and left side of the lower rows</SPAN></SPAN>
For example1: if we check in row 5 we have 3 diagonal with 2 match</SPAN> (first in cell E5=1 and cell F4=1) second in cell J5=1 and cell K4=1, and last (third in cell L5=1 and M4=1) </SPAN></SPAN>
For example1: if we check in row 6 we have </SPAN>3 diagonal with 2 match and 1 with 3 match</SPAN> (first in cell E7=1 and cell E6=1) second in cell F7=1 And cell G6=1, and 3 diagonal match are In cell F7=1, cell G6=1 and Cell E8=1</SPAN></SPAN>
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Game | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | Total match 2 diagonal | Total match 3 diagonal |
2 | 1 | 1 | |||||||||||||||
3 | 2 | 1 | 1 | 1 | |||||||||||||
4 | 3 | 1 | 1 | 1 | 1 | ||||||||||||
5 | 4 | 1 | 1 | 1 | 1 | 1 | 1 | 3 | |||||||||
6 | 5 | 1 | 1 | 1 | |||||||||||||
7 | 6 | 1 | 1 | 1 | 2 | 1 | |||||||||||
8 | 7 | 1 | 1 | 1 | 1 | ||||||||||||
9 | 8 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |||||||||
10 | 9 | 1 | 1 | 2 | |||||||||||||
11 | 10 | ||||||||||||||||
12 | 11 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |||||||||
13 | 12 | 1 | 1 | ||||||||||||||
14 | 13 | 1 | 1 | 1 | 1 | 2 | |||||||||||
15 | 14 | 1 |
<COLGROUP><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL></COLGROUP><THEAD>
</THEAD><TBODY>
</TBODY>
Mr.Excel
Results are shown in columns P And Q</SPAN></SPAN>
Please help</SPAN></SPAN>
Thanks And Regards,</SPAN></SPAN>
Moti</SPAN></SPAN>