Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Random Generator in Excel 2013

  1. Jul 29, 2013 #1
    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
     
  2. jcsd
  3. Jul 29, 2013 #2
    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)
     
Know someone interested in this topic? Share this thread via Reddit, Google+, Twitter, or Facebook




Similar Discussions: Random Generator in Excel 2013
  1. AVG 2013 problems? (Replies: 3)

Loading...