How to Randomly Select Multiple Cells in Excel 2013?

[StevieTNZ]

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

 

[Ivan92]

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)