Thread: Find 7....
View Single Post
  #5   Report Post  
Harlan Grove
 
Posts: n/a
Default

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 )