This is for the 3 digit dailey lottery numbers..
We want to count how many times each number
hit with each other..example the 3 hit with the zero
and 8 -----one time each so we would put a 1 there
H3 --- AND P3 AND SO ON...hope I explained it right.

Is there a formula that I can use to do this or do I
have to make a macro ?????and need big help...
Thank you
Bob in Michigan
EXAMPLE IN THE attachmentfile3DIGITADDANDCOUNT.xlsx