Results 1 to 1 of 1

Generating Combinations of Four "Strings" from large pool of strings!

Threaded View

Deathwreaker Generating Combinations of... 07-08-2014, 10:12 AM
  1. #1
    Registered User
    Join Date
    05-29-2014
    Posts
    5

    Generating Combinations of Four "Strings" from large pool of strings!

    So I want to take a large pool of strings, which in this case are names for moves, and create every possible combination of four of those strings from every string inputted into a large pool.

    The large pool, in this spreadsheet, is identified as moves. My goal is to create combinations of four of those moves, and each one is then inserted into its own smaller moves box under "Potential Sets".

    It seems to me that this is likely cumbersome to accomplish with formulas and so VBA coding is the proper way to tackle this challenge, but unfortunately my knowledge of VBA is limited.

    If you do successfully write a code to accomplish this, please provide a thorough analysis of what you used and how each element of the code functions. I am also looking to learn excel VBA myself.

    Thanks!
    Attached Files Attached Files
    Last edited by Deathwreaker; 07-08-2014 at 11:25 AM. Reason: more clarification

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Strings Variables in Range("A1").Formula = "=index/match" ?
    By nadnerb5 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-19-2012, 05:07 PM
  2. Colomn of strings, how to count each string with "abc" OR "def"
    By Tommy T in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-07-2005, 12:05 AM
  3. Colomn of strings, how to count each string with "abc" OR "def"
    By Tommy T in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 09:05 PM
  4. Colomn of strings, how to count each string with "abc" OR "def"
    By Ron Rosenfeld in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 09-06-2005, 08:05 PM
  5. [SOLVED] Colomn of strings, how to count each string with "abc" OR "def"
    By Tommy T in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 PM

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