newparadigmz
asked on
Excel VBA list pairing
I have 3 columns
apple goat sam
orange dog dave
pear cat matt
I need 3 columns of every combination (3x3x3 rows)
apple goat sam
apple goat dave
apple goat matt
apple dog sam
apple dog dave
apple dog matt
............
orange goat sam
orange dog dave
orange cat matt
.......
I'm sure this type of problem has a name, but I don't know it. sorry for the silly example
apple goat sam
orange dog dave
pear cat matt
I need 3 columns of every combination (3x3x3 rows)
apple goat sam
apple goat dave
apple goat matt
apple dog sam
apple dog dave
apple dog matt
............
orange goat sam
orange dog dave
orange cat matt
.......
I'm sure this type of problem has a name, but I don't know it. sorry for the silly example
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Welcome, glad that helped.
~bp
~bp
ASKER
Thanks