Random Generator in Excel 2013 - =RAND Calculation Help

Forums › Desktop computing › Random Generator in Excel 2013 - =RAND Calculation Help

StevieT

706 posts

Ultimate Geek
+1 received by user: 34

#127105 30-Jul-2013 10:28

Hi there,

In Office Excel 2013 -
If I make a list of five statements, each in a separate cell but within the same column, in another cell how can I get Excel to randomly select
three of those statements? Not sure how to write the =RAND() equation.

Any help will be much appreciated,
Stevie

littlehead

222 posts

Master Geek
+1 received by user: 102

#868378 30-Jul-2013 11:12

Just tested this in Excel 2010, so it probably should work in 2013.

For cells in column A in rows 1 to 13, to pick a single value:
=INDIRECT("A"&RANDBETWEEN(1,13))

The random cell chosen will update every time the sheet recalculates, so you may need to disable auto-recalculation for the sheet if you require the random value chosen to stay static.

sittingduckz

689 posts

Ultimate Geek
+1 received by user: 288

ID Verified

#868381 30-Jul-2013 11:19

I got something similar (but only to 5 rows)

=INDIRECT("A"&ROUNDUP(RAND()*5,0))

Edit: I like littleheads better I think

I'm not a complete idiot, I still have some parts missing.

Woolly

119 posts

Master Geek
+1 received by user: 22
Inactive user

#868382 30-Jul-2013 11:20

This should get you started

http://www.extendoffice.com/documents/excel/645-excel-select-cells-randomly.html

So you have 5 statements

AB
C
D
E

Use the above link to get your 3 random statements.

For D1 =CONCATENATE(C1,C2,C3) to put the statements in the one cell.

You could hide the B and C columns

I hope this is what you intended.

Cheers.