Find all possible numerical combinations

[amy22x3]

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

[mrice]

Have a look at

[MickG]

XLForum_ Amy22x3_Find all possible numerical combinations ---------------------
Hi Amy, try this:-
Place you line (Lot) of Data in Row (1)
Run the code Select Row (1) Range of Data in the "Input Box".
Enter the number "3" in the 2nd "Input Box" (This is your number selection, any number within the Row (1) range will work)
Results appear from "A2" on.
The results will be cleared each time you run the code.
The numbers of rows in the display will show in a Message Box.

Please Login or Register  to view this content.

NB:- I've jusy written it, give it a good test.
It seems all right so far !!
Regards Mick

[MickG]

Hi, I don't know how , but I seem to have shortchanged you on some variables.
Add these to the top of he code:-

Please Login or Register  to view this content.

Hope it still works !!
Regards Mick

[Tal72]

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?
Thanks,
Amy

Sorry but did you mean the number of combinations or do you have to show all the combinations?