+ Reply to Thread
Results 1 to 5 of 5

Insertion of Random Hashtags in each row of a column

  1. 08-15-2017, 07:08 PM #1
    WhatsGig
    WhatsGig is offline
    Registered User
    Join Date
    08-11-2017
    Location
    Chicago,USA
    MS-Off Ver
    2017
    Posts
    11

    Insertion of Random Hashtags in each row of a column

    Hello every one

    If any one can guide me to achieve this

    Idea

    I want to make a csv file containing say 10000 tweets (a single tweet in each row)
    Now I want to fill every row of another column with random hashtags not more than 140 characters. these hashtags be randomly fetched from data bank of hashtags stored in some other excel sheet so that every row could be filled with different hashtags. the total characters of different hashtags including spaces should not be 140 characters.

    Any guidance / help pls
    Reply With QuoteRegister To Reply
  2. 08-15-2017, 07:25 PM #2
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Insertion of Random Hashtags in each row of a column

    How do you make up a random tweet?

    What's the composition of a "random hashtag?"

    Maybe you could provide an example.
    Entia non sunt multiplicanda sine necessitate
    Reply With QuoteRegister To Reply
  3. 08-15-2017, 07:32 PM #3
    mehmetcik
    mehmetcik is offline
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Insertion of Random Hashtags in each row of a column

    Your Tweets in column A of Sheet1
    Your Hashtags in column A of Sheet2

    This formula in cell B1 of sheet1 and filled down.

    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by mehmetcik; 08-15-2017 at 07:34 PM.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.
    Reply With QuoteRegister To Reply
  4. 08-16-2017, 08:30 AM #4
    WhatsGig
    WhatsGig is offline
    Registered User
    Join Date
    08-11-2017
    Location
    Chicago,USA
    MS-Off Ver
    2017
    Posts
    11

    Re: Insertion of Random Hashtags in each row of a column

    Quote Originally Posted by shg View Post
    How do you make up a random tweet?

    What's the composition of a "random hashtag?"

    Maybe you could provide an example.

    As I'm using followlike" for tweets.

    IDEA
    Say, I have to tweet one thousand pictures after specific intervals. I will make csv file with the links of picture in each row of Column B.
    Now I need different Hashtags for each picture. So, what I want, is to make a data bank of different Hashtags and want to put multiple hashtags chosen randomly in Column A (the total character must be 140 including spaces)


    HASHTAGS TWEET
    #PICTURE #SocialMedia #Quotes #Landscape #Portrait #Motivation C://Images/1.jpg
    #Pic #Facebook #SEO #Photography #AI #Hobbies #USA #inspiration C://Images/2.jpg

    For all : Please guide & help to achieve this. I will be highly obliged
    Last edited by WhatsGig; 08-16-2017 at 08:38 AM. Reason: table n explanation added
    Reply With QuoteRegister To Reply
  5. 08-16-2017, 09:09 AM #5
    WhatsGig
    WhatsGig is offline
    Registered User
    Join Date
    08-11-2017
    Location
    Chicago,USA
    MS-Off Ver
    2017
    Posts
    11

    Re: Insertion of Random Hashtags in each row of a column

    Quote Originally Posted by mehmetcik View Post
    Your Tweets in column A of Sheet1
    Your Hashtags in column A of Sheet2

    This formula in cell B1 of sheet1 and filled down.

    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Thanks a lot Bro, it is indeed a great help for me. I simply did this to get multiple hashtags in a row

    =INDEX(Sheet2!A$1:A$2000,RANDBETWEEN(1,COUNTA(Sheet2!A$1:A$2000)),1)&" "&INDEX(Sheet2!A$1:A$2000,RANDBETWEEN(1,COUNTA(Sheet2!A$1:A$2000)),1)&" "&INDEX(Sheet2!A$1:A$2000,RANDBETWEEN(1,COUNTA(Sheet2!A$1:A$2000)),1)&" "&INDEX(Sheet2!A$1:A$2000,RANDBETWEEN(1,COUNTA(Sheet2!A$1:A$2000)),1)&" "&INDEX(Sheet2!A$1:A$2000,RANDBETWEEN(1,COUNTA(Sheet2!A$1:A$2000)),1)&" "&INDEX(Sheet2!A$1:A$2000,RANDBETWEEN(1,COUNTA(Sheet2!A$1:A$2000)),1)&" "&INDEX(Sheet2!A$1:A$2000,RANDBETWEEN(1,COUNTA(Sheet2!A$1:A$2000)),1)&" "&INDEX(Sheet2!A$1:A$2000,RANDBETWEEN(1,COUNTA(Sheet2!A$1:A$2000)),1)&" "&INDEX(Sheet2!A$1:A$2000,RANDBETWEEN(1,COUNTA(Sheet2!A$1:A$2000)),1)&" "&INDEX(Sheet2!A$1:A$2000,RANDBETWEEN(1,COUNTA(Sheet2!A$1:A$2000)),1)&" "&INDEX(Sheet2!A$1:A$2000,RANDBETWEEN(1,COUNTA(Sheet2!A$1:A$2000)),1)&""
    Is it Right way? to get the job done?

    Regards
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. freezing a column from insertion of other columns
    By sara ghaith in forum Excel General
    Replies: 2
    Last Post: 12-16-2013, 04:23 PM
  2. Arrows and Hashtags Appear When Printing
    By UCP in forum Excel General
    Replies: 6
    Last Post: 10-21-2013, 11:10 AM
  3. Transposing and insertion of rows into a column
    By thomsonjim in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 08-13-2012, 08:15 AM
  4. Conditional Formatting the Insertion of a Column
    By wmfinance in forum Excel General
    Replies: 2
    Last Post: 08-27-2010, 08:28 AM
  5. No column insertion in Copy code
    By flebber in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-27-2010, 04:37 AM
  6. Create a column upon insertion or overwriting of data.
    By Swiatkowski Peter in forum Excel General
    Replies: 1
    Last Post: 12-20-2005, 07:50 AM
  7. Proctect worksheet column/row insertion and deletions
    By kckmikeg in forum Excel General
    Replies: 1
    Last Post: 05-16-2005, 02:16 PM
  8. VB Random Number Generation/Insertion/NextWorksheet
    By Craig in forum Excel General
    Replies: 4
    Last Post: 02-27-2005, 07:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1