select value of a random cell

F

flashing frank

@Max:
Thank you very much. that is exactly what i was looking for. :)

And a special thanks for the tip to install the plugin.
you saved me a lot of time ;)




One way ..

Assuming this table is in Sheet1, in A1:D5
. A B C D
1 england red dog porsche
2 spain blue cat BMW
3 usa green mouse mercedes
4 greece yellow horse VW
5 germany black donkey jaguar
Click to expand...

In a new Sheet2
------------------
Put in A1: =INDEX(Sheet1!$A$1:$A$5,RANDBETWEEN(1,5))
Put in B1: =INDEX(Sheet1!$B$1:$D$5,RANDBETWEEN(1,5),RANDBETWE EN(1,3))

A1 will return a random value from Sheet1's A1:A5, while
B1 will return a random value from Sheet1's B1:D5

Just tap / press F9 to recalc and regenerate afresh

Freeze the values in A1:B1
by a copy > paste special > values elsewhere

Note: RANDBETWEEN requires the Analysis Toolpak
to be installed and enabled via: Tools > Add-Ins
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

select value of a random cell 1
MACRO RUN random percentage and copy of column values 1
VBA pick random cell - print 2
How do I set up a random Colum 1-55 without repeating a number 6
Need to Capture the initial value of a cell. 1
Macro for a one time triggered copy of cell value 8
get value of cell only 6
Macro that uses a cell value to copy another cell 3

Top