Combinations

Hi,

How in Excel can I create ALL permutations of a given data set? for example, imagine 5 columns. Each column has a differnet number of unique entries. Column 1 can be red, blue. Column 2 could be A, B, C, D, E and so on. I want to combine 1 item of each 5 columns and keep doing it until I create all possible combinations. The number of permutations (PERMUT) may be very large so I need to automate this.

Thanks!

Matt

Perfect! Thanks!!!