How to start a VBA to count couples out of my list ...

[The Wraith]

Hi,

How can i count the couples of 2 and 3 and 4 and 5 numbers out of my list of (6 numbers in a row) 3000 rows long...(excel2000)

- A1 till F6 (6 numbers)
- 3000 rows long
- all combinations of numbers 1 to 42 lotto

I do not find the good way to start making a VBA to count these couples ..

something that analyse each row ,number by number and count if each nr together with another nr exist more as 1 time in the total list of 3000 rows...even when 3 same numbers exists more times together...and 4 and 5....it is maybe to complex for all thes countings ?

greetings

 

[erik.van.geit]

Hi,
you received response here to the same question
didn't you see the reply ?
just answer and you will get more ...

kind regarrds,
Erik

 

[Von Pookie]

Please continue in your original thread:
http://www.mrexcel.com/board2/viewtopic.php?t=179095