+ Reply to Thread
Results 1 to 7 of 7

Include random word from the word list with a phrase as suffix or prefix

Hybrid View

  1. #1
    Forum Expert dosydos's Avatar
    Join Date
    12-09-2015
    Location
    MA, USA
    MS-Off Ver
    365(PC) V:2412
    Posts
    1,477

    Re: Include random word from the word list with a phrase as suffix or prefix

    Add a helper column to column A. label your phrases 1-1100 (or however many phrases you have).

    Column B are your phrases
    column C are your Terms
    i put the formula in cell D2. change references where applicable. recalculating, changin widths of columns, or pretty much anthing else randomizes this formula constantly so if you need it to be static, copy and paste values.
    In the formula below i have two instances of 1100 please change the 1100 too what ever the last number in column A is.

    =IF(RANDBETWEEN(0,1)=0,C2 & " " & VLOOKUP(RANDBETWEEN(1,1100),A:B,2,FALSE),VLOOKUP(RANDBETWEEN(1,1100),A:B,2,FALSE) & " " & C2)
    Last edited by dosydos; 03-09-2016 at 01:21 PM.

  2. #2
    Registered User
    Join Date
    09-23-2012
    Location
    Mumbai
    MS-Off Ver
    Excel 2010
    Posts
    61

    Re: Include random word from the word list with a phrase as suffix or prefix

    Hi Dosydos,

    Thanks a lot for this help. The function is working, perhaps if the prefix term gets added as suffix the phrase become meaningless.

    If we divide phrases in two groups 550 with random 'suffix only' and 550 with random 'prefix only'. This way I assume there will be two different function to use, one for each group (suffix and prefix)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Autocomplete search word based on Initial first/random word
    By radian89 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-19-2015, 11:51 PM
  2. Adding a random prefix and suffix to a cell
    By alexadept in forum Excel General
    Replies: 1
    Last Post: 04-02-2015, 07:42 PM
  3. [SOLVED] Search using a Word/Phrase
    By hiteshasrani43 in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 03-05-2015, 01:02 AM
  4. [SOLVED] Unique Random Words From Word List
    By uniks in forum Excel General
    Replies: 5
    Last Post: 03-03-2014, 06:42 AM
  5. Replies: 4
    Last Post: 02-23-2014, 08:18 AM
  6. Highlighting a word or phrase
    By bishoposiris in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-29-2013, 11:11 PM
  7. Replies: 0
    Last Post: 06-13-2012, 09:16 PM

Tags for this Thread

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