Hi,

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
I dont know the numbers ,I want to know which numbers (COMBINATION OF 7
)

Thanks


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

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?

http://tinyurl.com/8dfoq

Biff

"Harlan Grove" wrote in message
oups.com...
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?

11 random numbers 1 to 35 in (A1-K1)


1 3 7 8 13 23 27 29 30 33 34
6 8 9 12 15 20 21 22 24 25 28
1 2 17 18 19 22 25 26 28 31 35
8 9 13 14 15 18 19 22 27 30 31
5 8 11 14 17 18 20 23 24 26 30
9 12 19 24 25 26 28 29 30 33 35
3 4 7 8 13 14 23 24 26 27 33


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

laly wrote...
11 random numbers 1 to 35 in (A1-K1)

1 3 7 8 13 23 27 29 30 33 34
6 8 9 12 15 20 21 22 24 25 28
1 2 17 18 19 22 25 26 28 31 35
8 9 13 14 15 18 19 22 27 30 31
5 8 11 14 17 18 20 23 24 26 30
9 12 19 24 25 26 28 29 30 33 35
3 4 7 8 13 14 23 24 26 27 33

Use ancillary formulas in column L, e.g.,

L1:
=A1&" "&B1&" "&C1&" "&D1&" "&E1&" "&F1&" "&G1&" "&H1&" "&I1&" "&J1&"
"&K1

The tommost most frequently repeating combination would be given by the
array formula

=INDEX(A1:K1500,MODE(MATCH(L1:L1500,L1:L1500,0)),0 )

It not working ..... :(


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