CELL B1: 0 1 2 3 4 5 6 7 8 9 0 0 0 0 0 0 0 0 0 1 1 1 1 1 1 1 1 2 2 2 2 2 2 2 3 3 3 3 3 3 4 4 4 4 4 5 5 5 5 6 6 6 7 7 8
CELL B2: 0 1 2 3 4 5 6 7 8 9 1 2 3 4 5 6 7 8 9 2 3 4 5 6 7 8 9 3 4 5 6 7 8 9 4 5 6 7 8 9 5 6 7 8 9 6 7 8 9 7 8 9 8 9 9
SHEET3
COPY THIS DATA OF ALL THE PAIRS TO EXCEL
BOLD AN LARGE THE PAIRS GO FROME ROW 1 TO ROW 2 , I fill in red and make the numbers white
Next: IN CELL B3 COPY AND PAST THIS: =COUNTIF(B$6:B$2924,">=4") THEN COPY THIS AND ACCROSS TO THE RIGHT FILL B3-K2 THIS TAKES CARE OF THE DOUBLES
NEXT: CELL L1 COPY AND PAST THIS: =COUNTIF(L$6:L$2924,2) THEN COPY THIS AND FILL ACCROSS TO THE RIGHT
NEXT: CELL B6 COPY AND PAST THIS: =COUNTIF(Sheet2!$F1:$H1,B$1)+COUNTIF(Sheet2!$F1:$H1,B$2) THEN COPY THIS AND ACCROSS TO THE RIGHT FILL B3-K2 THIS TAKES CARE OF THE DOUBLES
NEXT: CELL L1 COPY AND PAST THIS: =COUNTIF(Sheet2!$J1:$L1,L$1)+COUNTIF(Sheet2!$J1:$L1,L$2) THEN COPY THIS AND FILL ACCROSS TO THE RIGHT
NOW SELECT THE SAME ROW B6 COPY THEN DOWN AND PAST 1000 ROW SHOULD DO IT , DONT FILL JUST TO BE SAFE!
NEXT YOU NEED THE RESUTS OF THE 0 TO GET COUNTED THEY ARE THE NUMBERS THAT DID NOT SHOW UP BECAUSE
ON SHEET 2 YOU DECIDED HOW MUCH DRAWING YOU WATED TO COVER WITH THE FIRST SET OF FOMULA FOR THE DOUBLES KEEP IN MIND THAT THE SINGLE PAIR ONLY WORKS IF THERE IS DATA IN THE FOMULA FOR THE DOUBLES
NEXT THE 0 COUNT OF ALL THE DOUBLES : IN CELL A2 : =COUNTIF($B4:K4,0)
NEXT THE 0 COUNT OF ALL SINGLE PAIR : =COUNTIF(L4:$IV4,0)
ON SHEET2 YOU MAY WANT TO TRAKE THE RESULT FROME SHEET3 SO THAT YOUR GETING THE ONE U WANT SO IN CELL E2 UNDER THE WORDS DOUBLES PAST THIS =Sheet3!$A$3 DOWN 500 IS MORE THAN ENOUGH
THEN CELL I1 UNDER THE WORDS SINGLE PAST =Sheet3!$A$4 DOWN 500
PLEASE LET ME KNOW WHEN IT"S DONE OR PROBLEMS NOTE DATA HISTORY NO TEXT ABOVE THE NUMBERS