if i had the letters A,B,C,D,E,F,G,H,I in cells A1 thru A9, how could i show all combinations of these nine letters (one letter per cell) in columns B thru J? this would include A, B, AB, ABC, ABCD, etc. per the formula for combinations without replacement, i know i should end up with 511 different combinations (thus, the solution will use 511 rows). any suggestions for how to do with without using macros?
I will hazard at a guess - without macros = no can do. Why pray tell do you want to do this?
i need to write some code in a separate software program to cover all possible combinations of the 9 letters (each letter represents a different company in my analysis). and i normally use excel to layout the code before cutting and pasting back to the original software syntax screen.
so if it can't be done without macros, does anyone have the macro code to do this? thanks in advance for any help.
Good evening pilot4fun
You can do it using macros, but it isn't quick, and going up to 9 digits is going to take some time to calculate. I haven't got time to take you through a dedicated example, but have a lok at the file below.
It started as a word game I was designing, but it ran too slow, so I eventually abandoned the idea. Basically, the file takes a six letter word from a list of 5,580 and scrambles it and the user has to guess the six letter word(s) and any other shorter words. Click on the Find Words button to kick off the routine you're interested in. This takes a few seconds for 6 letters and would take far longer for seven letters - eight or nine letters would be virtually unusable - maybe that's just 'cos I'm checking the spelling at the same time.
HTH
DominicB
Last edited by dominicb; 08-19-2008 at 04:29 AM.
Please familiarise yourself with the rules before posting. You can find them here.
This will put all the permiutations that you want in column A. If you want to pemute more or fewer letters, change letterCount. If you want the result column to be somewhere else, change printPlace. You should be aware that it puts "" in the 512th row.
Please Login or Register to view this content.
Last edited by mikerickson; 04-16-2007 at 11:29 PM.
Thank you mikerickson! Using your code I was then able to convert the 511 combinations of A,B,C,D,E,F,G,H,I into words. THANK YOU!
Originally Posted by mikerickson
This will put all the permiutations that you want in column A. If you want to pemute more or fewer letters, change letterCount. If you want the result column to be somewhere else, change printPlace. You should be aware that it puts "" in the 512th row.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks