Results 1 to 9 of 9

Generating Combinations of Text

Threaded View

financeguy57 Generating Combinations of... 10-19-2010, 01:31 PM
JimmyA Re: Generating Combinations... 10-19-2010, 01:46 PM
6StringJazzer Re: Generating Combinations... 10-19-2010, 02:29 PM
6StringJazzer Re: Generating Combinations... 10-19-2010, 02:43 PM
financeguy57 Re: Generating Combinations... 10-19-2010, 04:08 PM
financeguy57 Re: Generating Combinations... 10-19-2010, 04:36 PM
6StringJazzer Re: Generating Combinations... 10-19-2010, 05:03 PM
financeguy57 Re: Generating Combinations... 10-19-2010, 05:07 PM
shg Re: Generating Combinations... 10-19-2010, 06:42 PM
  1. #1
    Registered User
    Join Date
    10-19-2010
    Location
    New York
    MS-Off Ver
    Excel 2003
    Posts
    11

    Generating Combinations of Text

    Hi,

    I am trying to find a way to generate all possible combinations from a list. The requirements of this specific task differ from other posts I've read.

    1. Each combination should maintain the order of the rows and thus eliminate duplicates caused by switching fields. ex: Column A: Dog Column B: fur = Dog,fur NOT fur,dog

    2. This is text based as each column represents a parameter for systems testing and thus each column must be included in each result. => every result should have 8 variables generated.

    3. Currently I have 8 columns each with a different number of variables (<5 in each) but i would like to be able to change this in the event we need to add further categories.

    Any guidance provided would be greatly appreciated and a huge time saver!
    Many Thanks.
    Last edited by financeguy57; 10-19-2010 at 05:09 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1