Thursday, February 23, 2017

yogi_From Table A:E Select A Column Randomly Then Randomly Select An Entry From Within That Column

Google Spreadsheet   Post  #2121
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Feb-23-2017
question by 'You Can Be Me':
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/lq1qZEr0zmI;context-place=forum/docs
Pull random data from 5 different columns
Hi,

I would like help on part 1 and also part 2 if it's possible please:

1)  I have 5 columns with 40+ rows of data each.  Row 1 contains the titles for each column.  I want to randomly pull the title of a column into a cell, and then randomly pull an item from within that column.
2)  Same as number 1 but I'd also like to select sequentially so that data from each column is represented and listed one after the other (1,3,4,2,5 .....then next time  3,4,1,5,2......etc.)
Your help is appreciated.

No comments:

Post a Comment