All Combinations of cell values in a single Column

noname

Guest

Posts: n/a

15th Jul 2010

Hi,

I need to create different combinations of a cell with the ones below
it.

for e.g:

Column A
--------------
A1
A2
A3
A4

Output:
----------
A1
A1A2
A1A3
A1A4

A2
A2A1
A2A3
A2A4

A3
A3A1
A3A2
A3A4

A4
A4A1
A4A2
A4A3

« Removing duplicates but leaving data on following rows | Using XLM Macro Sheet in Excel 2010 »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VLookup multiple values - sum returned values into single cell	se7098	Microsoft Excel Worksheet Functions	11	18th Sep 2008 12:04 AM
Combinations from values in a column	Andreas	Microsoft Excel Discussion	7	25th Apr 2008 05:27 AM
median of combinations from values in a column	Andreas	Microsoft Excel Programming	6	24th Apr 2008 09:23 PM
From single cell variables to a single column serie	=?Utf-8?B?bm95YXU=?=	Microsoft Excel New Users	1	22nd Dec 2006 06:43 AM
Convert column values into a single cell	gldweb	Microsoft Excel Misc	9	20th Aug 2004 09:27 PM