Help with an excel situation

[golfpro63]

I am trying to find repeating numbers in a large page of lottery results
the lotto is keno and I have 20 number combination results
I want to find all repeating combos with the same 10 numbers out of the past drawn results

numbers are located in E2 TO X2601.
Does anyone know a formula for this?

Thank you

John

 

[ranman256]

(assuming each number is in 1 column) make function in column 11 that concatonates all 10 nums: = CONCAT(A2,"-",B2,"-",C2,"-",D2,"-",e2,"-",f2,"-",g2,"-",h2,"-",i2,"-",j2)
dbl-click it so it copies all down the list.
make a pivot table to count each combo.