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.