[Excel] How to do this?

Status
Not open for further replies.

Sushant Pawar

Senior Member
Joined
Mar 7, 2018
Messages
810
Reaction score
322
I have made 3 lists of hashtags in Excel.
I want to make 4th list in which a row should have random 15 hashtags from list A, 10 hashtags from list B and 5 from list C

Is there any command or function in Excel to do this?
 
Apply this formula to the cells in Column D
Your 3 lists as mentioned in columns A, B, and C ...the rand function is volatile so copy the cells in column D and paste as values in a new column or sheet
=@INDIRECT("A"&RANDBETWEEN(1,15)) & " " &@ INDIRECT("B"&RANDBETWEEN(1,10)) & " " &@ INDIRECT("C"&RANDBETWEEN(1,5))
 
Status
Not open for further replies.
Back
Top