Geekzone: technology news, blogs, forums
Guest
Welcome Guest.
You haven't logged in yet. If you don't have an account you can register now.




601 posts

Ultimate Geek
+1 received by user: 26


Topic # 127105 30-Jul-2013 10:28
Send private message

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

Create new topic
123 posts

Master Geek
+1 received by user: 30


  Reply # 868378 30-Jul-2013 11:12
Send private message

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.

448 posts

Ultimate Geek
+1 received by user: 104


  Reply # 868381 30-Jul-2013 11:19
Send private message

I got something similar (but only to 5 rows)

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


Edit: I like littleheads better I think

 
 
 
 


119 posts

Master Geek
+1 received by user: 22
Inactive user


  Reply # 868382 30-Jul-2013 11:20
Send private message

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.





Create new topic



Twitter »

Follow us to receive Twitter updates when new discussions are posted in our forums:



Follow us to receive Twitter updates when news items and blogs are posted in our frontpage:



Follow us to receive Twitter updates when tech item prices are listed in our price comparison site:



Geekzone Live »

Try automatic live updates from Geekzone directly in your browser, without refreshing the page, with Geekzone Live now.



Are you subscribed to our RSS feed? You can download the latest headlines and summaries from our stories directly to your computer or smartphone by using a feed reader.

Alternatively, you can receive a daily email with Geekzone updates.