Combination of Values in Cells

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

Combination Of Values In Cells

Rate this: (3/5 from 1 vote)

	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:   A B C D E F 1   Short Nick  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 coolz on 01 Mar 2007

Replies - Displaying 1 to 1 of 1

Order Replies By: Most Recent | Chronological | Highest Rated

	A solution found ! 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 coolz on 01 Mar 2007

Displaying page 1 of 1