Google Spreadsheet Post #2121
Pull random data from 5 different columns
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.
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/docsPull random data from 5 different columns
Hi,
I would like help on part 1 and also part 2 if it's possible please:
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