laly Wrote:
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
Hi Laly
Assuming your data to be in Columns A - Q, in column S put the numbers
from 1 - 70
In column T use this formula =COUNTIF($A$1:$Q$1500,S1), drag down, you
will now have a count of how many times each number is used
--
Paul Sheppard
------------------------------------------------------------------------
Paul Sheppard's Profile:
http://www.excelforum.com/member.php...o&userid=24783
View this thread:
http://www.excelforum.com/showthread...hreadid=468056