How to Randomly Select Multiple Cells in Excel 2013?

Join the discussion
Ask a follow-up here, or get your own question answered by working scientists, mathematicians and engineers — people, not an autocomplete.
Real named experts · corrections over time · the nuance an AI answer skips
Sign up Log in
1 reply · 3K views
StevieTNZ
Messages
1,944
Reaction score
837
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
 
Physics news on Phys.org
Assuming it is all in column A:

=INDEX($A#:$A#,RANDBETWEEN(1,COUNTA($A#:$A#)),1)

Where # represent the row it is in. So if your list is from A1 to A5, it would be

=INDEX($A1:$A5,RANDBETWEEN(1,COUNTA($A1:$A5)),1)