So I have 4 columns in this table:



Color1 Color 2 Color 3 Color 4

Yellow Yellow Blue Blue

Pink Pink Brown Brown

White White Black Black

SO my goal is to create all possible combinations without having duplicates. I was thinking of using Cartesian join, but I'm not sure if that will work with multiple tables. Anyone have a way to do this without VBA?
End result looks something like this:
Yellow Pink Blue Brown
Yellow Pink Blue Brown
Yellow Pink Blue Black
Yellow Pink Brown Black
ect..

Cross-posted (and answered) at: http://www.excelforum.com/excel-gene...uplicates.html

For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]