how do I make a list of unique combinations from a series of variables

**bjas** · 02-07-2011, 06:10 AM

Hi

I need to make a list of unique combinations from a series of variables

I have 5 variables, A, B, C, D, E

These can hold 5 unique values each (A1, A2, A3, A4, A5, B1, B2, B3 etc etc)

from these variables I want to make a list of all unique cominations that these variables and values can generate, like this

A1B1C1D1E1
A2B1C1D1E1
A3B1C1D1E1
.
.
.
A1B2C1D1E1
A1B3C1D1E1
.
.
.
A5B5C5D5E5

How do I do this?

Thank you in advane

**DonkeyOte** · 02-07-2011, 09:31 AM

@bjas, if you feel you need to cross post given lack of response please ensure you revert to your other threads and add links accordingly

http://www.mrexcel.com/forum/showthread.php?t=527084

this is outlined in Rule 8 of our Form Rules.

Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Read this to understand why we ask you to do this

**TMS** · 02-07-2011, 11:46 AM

Please Login or Register  to view this content.

Regards

**bjas** · 02-08-2011, 04:11 AM

TMShucks --> Works likea charm!

Thank you so much!

**bjas** · 02-08-2011, 04:21 AM

One more thing I thought of.

is there an easy way to get the code to automaticaly detect if there are more or less than five entries in a column?

If I for example only use 3 variables for A (a1, a2, a3) but 6 for B (b1,b2,b3,b4,b5,b6), can I make the code realise this without me interfering?

I think i understand how I can do this manually, by editing the code.

Again, thank you

**TMS** · 02-08-2011, 04:58 AM

One way:

Please Login or Register  to view this content.

**shg** · 02-08-2011, 10:02 AM

You can also do this with formulas. See http://www.box.net/shared/ubd28tissi

**bjas** · 02-11-2011, 06:58 AM

thank you!!!!

how do I make a list of unique combinations from a series of variables

LinkBack

Thread Tools

Rate This Thread

Display

how do I make a list of unique combinations from a series of variables

Re: how do I make a list of unique combinations from a series of variables

Re: how do I make a list of unique combinations from a series of variables

Re: how do I make a list of unique combinations from a series of variables

Re: how do I make a list of unique combinations from a series of variables

Re: how do I make a list of unique combinations from a series of variables

Re: how do I make a list of unique combinations from a series of variables

Re: how do I make a list of unique combinations from a series of variables

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions