E
excalibur
I am analising numbers draw in a lotto based on subsets I have 1000 sets of
five number to convert to sets of 2,3 & 4s for example a set of five numbers
would convert to 5 sets of 4s based on all the possible combinations of the
five numbers.Its very time consuming and I would like to write a macros in
excel 2000 using visual basic using a loop that would convert each line
automaticalyy but I'm not familiar with the process and vb lanuage. First of
all ...can it be done and if so how. thanks in advance
five number to convert to sets of 2,3 & 4s for example a set of five numbers
would convert to 5 sets of 4s based on all the possible combinations of the
five numbers.Its very time consuming and I would like to write a macros in
excel 2000 using visual basic using a loop that would convert each line
automaticalyy but I'm not familiar with the process and vb lanuage. First of
all ...can it be done and if so how. thanks in advance