Hi, I have data in the cell range A1:A52
I'm interested in 3 item combinations.
I'd like to generate the entire list of 22,100 three item combinations.
How do i do this?
Thanks in advance.
Hi, I have data in the cell range A1:A52
I'm interested in 3 item combinations.
I'd like to generate the entire list of 22,100 three item combinations.
How do i do this?
Thanks in advance.
of those list of 26 pairs there are only 1140 combinations,what do you mean exactly?
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
See attached. Copy the formulas down 22,000-odd rows.
Entia non sunt multiplicanda sine necessitate
Change the formula in E2 toThey should run something like: ackcqc, ackcjc, ackctc
=INDEX(Inp!$A$1:$A$52, C2+1) & INDEX(Inp!$A$1:$A$52, B2+1) & INDEX(Inp!$A$1:$A$52, A2+1)
and delete columns F:G
It's a UDF I added to the workbook I posted.
my mistake my comb checker only does up to 20 items i didn't notice on copy paste!!!!!!!!
Is there a way to change this from a function to a subroutine? Rather than have an input and output sheet, I would like to have the program take the data in cells A1:A52, generate the 22,100 combinations and place them in cells B1:B22100. If possible, I would like to have this as a macro that I can run rather than manually copy a formula down 22,100 rows.
Last edited by smiso24; 04-12-2010 at 09:59 AM.
Can anyone help with this?
Try this one:
Please Login or Register to view this content.
Sorry about that. I misread your last post.
change this:
toPlease Login or Register to view this content.
Please Login or Register to view this content.
Wonderful! Thank you so much!
I do apologize but I have another question. I have modified the spreadsheet such that the relevant data has been moved to column B. There is data in cell A1 which is NOT to be a part of the combination generating process. Can you re-write the code so the output is placed in column C and does not disturb cell A1 ?
I greatly appreciate your time and effort.
Disregard my last post. I think I finally got it squared away. Thank you again for all the help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks