Thread: Combinations
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mattxcore77 Mattxcore77 is offline
external usenet poster
 
Posts: 2
Default 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!!