View Single Post
  #1   Report Post  
LAdekoya
 
Posts: n/a
Default Need to derive combinations for 4 elements each with 3 possible va

I have four data elements and each can have one of three possible data values
at any one point in time. How can I auto-generate in excel, the various
possible data value combinations/mixes that I can get for these four items?
Assume the data elements are 1, 2, 3 & 4 and that the possible values are a,
b & c. Any help would be greatly appreciated.