Excel Help--Don't know exactly how to, worried about feasibility.

[Bartender]

I can do that, no problem. My problem is, I don't know how to get the function working. I intended to use the iteration value to generate each combination in order, but I ran into a roadblock, both with trying to obtain -in sequence- every combination of the 10 numbers, and with trying to reference back to the spreadsheet though I probably can figure the reference part out.

Also, I thought of something that might be important: the numbers could repeat in the spreadsheet cells. In other words, I might have repeat numbers in my combinations, though no number in a given cell may repeat.
If my numbers are 1,2,3,4,5,6,7,8,9,10, then this is not an issue, but if my numbers are 2,5,15,20,2,3,4,7,8, then the number 2 will be used twice.

Thanks again for any advice.

[Ecniv]

You need to have a loop and counter upwards from a number. When you reach the max number, it resets the previous number up one and sets itself to one up on that number.

eg:
Starts
1,2,3,4,5,6
1,2,3,4,5,7
1,2,3,4,5,8
etc
1,2,3,4,5,49
1,2,3,4,6,7

Try coding a loop like that and see what happens.