I've got 5 different items per lot and I have 6 lots: 1A, 1B, 1C, 1D, and 1E are the numbers for Lot 1. The sequence would repeat with 2A, 2B, etc..on up to 6A through 6E.

Is there a fast way to determine all possible combination of sets of three? For example, so far I've got: 1A - 1B - 1C, 1A-1B -1D, and so on. I'm doing this manually in Excel and it's taking me a while. Does anyone know of a better way?

P.S. I will be working my way up to combinations of 11 in a set.

Thanks,

Amy