Hi ,

Please if someone can help me with this…
I have a worksheet 1500 lines with 17 random numbers, 1 to 70.
How I can find 9 or 10 numbers from 17 that are keep repeating over and
over
again ...
Here is the example

1 19 24 28 29 34 36 37 43 46 47 50 54 55 59 63 70
3 7 9 11 16 20 22 23 26 32 37 39 49 52 55 66 67
2 4 16 21 24 26 28 29 34 38 39 41 49 57 64 67 70
7 8 9 10 14 16 21 23 25 36 43 50 51 55 61 65 70
12 14 18 21 30 36 37 43 44 47 48 49 51 52 54 55 64
8 12 13 19 23 25 27 31 32 33 36 40 44 46 60 62 64


Thanks in advance

Laly


--
laly
------------------------------------------------------------------------
laly's Profile: http://www.excelforum.com/member.php...o&userid=27303
View this thread: http://www.excelforum.com/showthread...hreadid=468056