|
-
Jun 29th, 2005, 10:25 AM
#5
Thread Starter
Member
Re: Excel Help--Don't know exactly how to, worried about feasibility.
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|