Home > Forum Home > Automating Data Analysis Tasks > Combination of Values in Cells Share

Combination of Values in Cells

Excel Help for Combination Of Values In Cells in Automating Data Analysis Tasks


Forum TopicPost Reply Login

Combination Of Values In Cells

Rate this:
(3/5 from 1 vote)
Confused I have attached a sheet on which I am hoping to get your help.

The sheet has 6 columns, and each column has values in the rows below it. I have to get all the unique strings possible by combining the different values in each of these columns. For example, two such combinations would be -

1. Short Nick Tina Buy Winter Fire
2. Short Tom Tina Buy Winter Fire

As you can see, I have changed the value in column 2 (Nick to Tom) while keeping the values in the other columns the same. So each unique string needs to have at least one value from each column.

Can someone help me with a quick way of listing out all the possible combinations ?xcel Spreadsheet:
 ABCDEF
1  ShortNick 
Tina Buy Winter Fire 
2 Tall Tom Sam Sell Summer Water
3 Medium Perry Nancy Cancel Spring Earth
4  John Colin Repurchase  
5  Bob  Sell back  
6    Buy back  
7      
 Posted by on
 
Replies - Displaying 1 to 1 of 1Order Replies By: Most recent | Chronological | Highest Rated
Confused
Rate this:
(3/5 from 1 vote)
I finally found a solution for this, and am thrilled !

[http://www.digdb.com/excel_add_ins/mix_match_sets_all_combinations/]

Thanks to all of you who took time to read this post.
 Posted by on
 Displaying page 1 of 1 

Find relevant Excel templates and add-ins for Combination of Values in Cells in the