# Thread: Generating All Possible Combinations - 4 Duplicate Lists

1. ## Generating All Possible Combinations - 4 Duplicate Lists

Hello!

I'm really struggling to list all combinations of 4 duplicate lists that I have. I would MASSIVELY appreciate some help on this as I cant see on the forum anyone with quite the same issue, apologies if this is somewhere out there though.....! :S

Here is what I have:

 Type 1 Type 2 Type 3 Type 4 40 or less 40 or less 40 or less 40 or less 50 or less 50 or less 50 or less 50 or less 60 or less 50 or less 50 or less 50 or less 70 or less 70 or less 70 or less 70 or less 80 or less 80 or less 80 or less 80 or less 90 or less 90 or less 90 or less 90 or less 90 or more 90 or more 90 or more 90 or more

I'm trying to get to the point where I can list all combinations of the above. The Types must remain in the same order, but the values are to mix. An example of this would be below:

 Type 1 Type 2 Type 3 Type 4 40 or less 50 or less 60 or less 70 or less 70 or less 70 or less 90 or less 90 or more 60 or less 40 or less 90 or more 90 or more

Does anyone have any suggestions?

Thanks so much everyone,
Matt

2. In the attached:
1. Columns F:I contain formulae to give all numbers from 1 to 7 in all their combinations (the 4 cells F1:I1 copied down).
2. A little INDEX formula in columns K:N which uses the numbers in F:I (cell K1 copied across and down).
3. Columns P:S is just a merge of the formulae in 1 and 2 above, and gives the same result.
4. Columns U:X is the values of P:S with Remove Duplicates applied (you have 50 or less appearing twice in each of Types 2,3, & 4).
5. BTW, a 90 would go into where; 90 or less, or 90 or more, or both?