laly wrote...
I have a woksheet with 11 random numbers 1 to 35 in (A1-K1)
i like to know what combination of 7 numbers from 11 ...are the most
repeat in A1-A1500
....

Unclear.

It seems you have 11 numbers drawn at random without replacement from 1
to 35 in cells A1:K1. It seems you also have something in cells
A1-A1500. Is that a different cell A1? Or is the first random integer
in A1 also always the first number in the range A1:A1500?

What *exactly* is in each cell in A1:A1500? Individual numbers in the
range 1 to 35 or strings of 7 space-separated integers drawn without
replacement from 1 to 35?