+ Reply to Thread
Results 1 to 2 of 2

Random Number Generator

  1. #1
    Registered User
    Join Date
    12-13-2012
    Location
    Mumbai
    MS-Off Ver
    Excel 2003
    Posts
    10

    Random Number Generator

    I have attached excel file which contains :
    Column 1: Definite
    Column 2: Optional

    I want to generate list of 2 words adgroups, 3 word adgroups & 4 word adgroups.. Here is how..

    Column 3: 2 words adgroups
    Take 1st word from column 1
    Take 1st word from column 2

    Take 1st word from column 1
    Take 2nd word from column 2

    Column 4: 3 words adgroups
    Take 1st word from column 1
    Take 2nd word from column 2
    Take 3rd word from column 2

    Column 5: 4 words adgroups
    Take 1st word from column 1
    Take 2nd word from column 2
    Take 3rd word from column 2
    Take 4th word from column 2

    I want to generate all possible keywords.. Could anyone tell me how to do this..

    I am attaching Excel file for the same..

    Pls help.. Thanks a million in advance

    Random-Keyword-Reqd.xlsx

  2. #2
    Registered User
    Join Date
    08-22-2012
    Location
    Zagreb, Croatia
    MS-Off Ver
    Excel 2003
    Posts
    61

    Re: Random Number Generator

    Hi gandhikr,

    find attached solution for your problem. Solution is based on calculating 2nd 3rd 4th pairs from row values. Calculating columns you can hide.

    Regards,
    Attached Files Attached Files
    If a post helps press star sign 4 my reputation

+ Reply to Thread

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