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


# 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
139 posts

Master Geek


  # 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.

481 posts

Ultimate Geek


  # 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
Inactive user


  # 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 and LinkedIn »



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:





News »

Chorus to launch Hyperfibre service
Posted 18-Nov-2019 15:00


Microsoft launches first Experience Center worldwide for Asia Pacific in Singapore
Posted 13-Nov-2019 13:08


Disney+ comes to LG Smart TVs
Posted 13-Nov-2019 12:55


Spark launches new wireless broadband "Unplan Metro"
Posted 11-Nov-2019 08:19


Malwarebytes overhauls flagship product with new UI, faster engine and lighter footprint
Posted 6-Nov-2019 11:48


CarbonClick launches into Digital Marketplaces
Posted 6-Nov-2019 11:42


Kordia offers Microsoft Azure Peering Service
Posted 6-Nov-2019 11:41


Spark 5G live on Auckland Harbour for Emirates Team New Zealand
Posted 4-Nov-2019 17:30


BNZ and Vodafone partner to boost NZ Tech for SME
Posted 31-Oct-2019 17:14


Nokia 7.2 available in New Zealand
Posted 31-Oct-2019 16:24


2talk launches Microsoft Teams Direct Routing product
Posted 29-Oct-2019 10:35


New Breast Cancer Foundation app puts power in Kiwi women's hands
Posted 25-Oct-2019 16:13


OPPO Reno2 Series lands, alongside hybrid noise-cancelling Wireless Headphones
Posted 24-Oct-2019 15:32


Waikato Data Scientists awarded $13 million from the Government
Posted 24-Oct-2019 15:27


D-Link launches Wave 2 Unified Access Points
Posted 24-Oct-2019 15:07



Geekzone Live »

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


Support Geekzone »

Our community of supporters help make Geekzone possible. Click the button below to join them.

Support Geezone on PressPatron



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.