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,
  2. jcsd
  3. Jul 29, 2013 #2
    Assuming it is all in column A:


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

Share this great discussion with others via Reddit, Google+, Twitter, or Facebook