ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Combinations (https://www.excelbanter.com/excel-programming/423381-combinations.html)

Mattxcore77

Combinations
 
I know this is probably posted somewhere, but I couldn't find the answer. Any
help is warmly appreciated:

I need code for combining strings stored in three different arrays:

1st array - "A"
2nd array - "BCD"
3rd array - "ABD"

The number of characters in each array can change from 1-3.

I want to store the 9 combinations in a new array (for this example):

ABA
ABB
ABD
ACA
ACB
ACD
ADA
ADB
ADC


Thanks in advance!!

Mattxcore77

Combinations
 
Actually I just figured it out, no need to reply.

"Mattxcore77" wrote:

I know this is probably posted somewhere, but I couldn't find the answer. Any
help is warmly appreciated:

I need code for combining strings stored in three different arrays:

1st array - "A"
2nd array - "BCD"
3rd array - "ABD"

The number of characters in each array can change from 1-3.

I want to store the 9 combinations in a new array (for this example):

ABA
ABB
ABD
ACA
ACB
ACD
ADA
ADB
ADC


Thanks in advance!!



All times are GMT +1. The time now is 10:13 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com