Hi!

I have this numbers 19 24 28 29 43 46 47 50 63 70
I like to know if the same combination (all) numbers repeats

Put the above numbers in a range, say, T1:AC1

Then, in R1 enter this formula:

=SUMPRODUCT(--(ISNUMBER(MATCH(T$1:AC$1,A1:Q1,0))))

Copy down as needed.

In column R all formulas that return 10 mean that all 10 of the number
combinations are in that row.

Then to get the total:

=COUNTIF(R:R,10)

Biff

"laly" wrote in message
...

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