Hi,
I am having a data set which contain 10 different unique name in one column. I would like to make a combination of names on the basis of avilabe sample data. If I define to make a combination of two like 1-2,1-3,1-4, ...1-10,2-3,2-4......,2-10, 3-4,3-5....,3-10 ,9-10 or three like 123, 124, 125...1210 similarly 134..1310 or four, five, six,seven, eight, nine. In this way, I have make a combination between thousand of data.
do you mean that in your example you now have 10 names, but later that 'll be thousand ?
you have to know 10 names by pair gives 10!/8!/2! = 45 combinations , 1000, that's 1000!/998!/2! = infinite.
Otherwise, it's not that difficult to program, but it's better to know before I start.
Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Yea, Exactly 10 names by pair gives 45. But I am having 200 names in one file and have to do calculation several files. Here one more line I would like to add. I am interested to know about combination of two, three, four and so on.Originally Posted by bsalv
i hope you don't do this with 200 names !!!
I suppose next question is "give me 100 unique combinations of 10 names from those 200 names".
Dear Bsalv,
Thankyou very much for your kind of support and really it is worthful for me. You know Actually it is working but not working with my dataset.
Simply Name1 (5 character, refered in example) = 600 character (Its a biological data with combination of AGCT, my dataset) and approximetely 4704 name (or data set) is with me. For demo purpose when I replaced existing 16 name with my 16 different data set (Each cell is having <=500 character), I got an error like "Run time error '13' in same error screen in second line msg like "Type mismatch" is printed.
I really appreciate if you will be shortout this. If required I love to share my sample data set.
you are working with DNA-sequenses ?
You get that error as soon as the text > 255 long, so that's immediately in your case.
Suppose, you have your 4.704 names of max. 500 characters. What do you want to do with it now ?
Perhaps, it's better to share you sample data set and (a part of) the desired result.
Yes, I am working with DNA sequence and Sample data is attached with it. Is it possible for you to avoid the maximum length of the name. But any way I have mentioned the maximum length of the name in sample data sheet also.
same macro, but the export is cell by cell instead of the whole dictionary in once.
As your strings are so long, it seems like the empty cells (cells with with background) aren't empty, but if you move your cursor to those cells, you'll see they are empty. Only the grey cells have values !
Last edited by bsalv; 02-04-2014 at 02:32 AM.
There's a workbook that will do this at https://app.box.com/s/b9b9fc06beb63b9562f9
Entia non sunt multiplicanda sine necessitate
@shg
That's a nice workbook but
- in some cases, the number of combinations 'll be greater then the number of rows in a worksheet (>1.000.000).
- the length of the names is also a problem to show.
I can think of no useful application for listing more than a million of anything, nor is it germane to the stated problem.
I don't understand the issue about the length of names.
Last edited by shg; 02-04-2014 at 02:58 AM.
The names are DNA-sequences and have a length of >500 (some are 3.000 long) and there are 4.700 names.I don't understand the issue about the length of names.
I did the programming, I don't know how the TS is going to use it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks