How to Generate Random Numbers in LibreOffice Calc

Поділитися
Вставка
  • Опубліковано 14 гру 2024

КОМЕНТАРІ • 9

  • @nobbymorph
    @nobbymorph Рік тому +1

    Very nice tip, however, how do we restrict the random number to be a non-repeating random number?

    • @officenifty
      @officenifty  Рік тому +4

      Thank you for that question! I think the simplest way is to first generate the random numbers in a column, and then remove duplicates from the column.
      Here's my newest video about removing duplicates: ➡ ua-cam.com/video/8yYRpcOnCO4/v-deo.html
      Another way is to first create a column of all the numbers you want to be "randomized" (e.g. a range from 1 to 1000), with non-repeating numbers. Then in a column next to it, apply the *=RAND.NV()* function (e.g. for 1000 rows, the same number of rows as your first column). Then, select both columns and sort Ascending by the second column. This will re-order the first column and it will appear to be in random order.
      If you would like, you may watch a short video I previously made about sorting two columns together: ➡ ua-cam.com/video/AFBQ2SOYCJ8/v-deo.html
      I hope this helps, and have a great day!

  • @gdmt
    @gdmt 3 місяці тому +1

    I tried doing randbetween(0.1,1.899) and it doesnt seem to return values like 1.623 or anything with a decimal. Kept returning whole numbers. Am i doing it wrong?

    • @officenifty
      @officenifty  3 місяці тому

      You are not wrong. Randbetween() returns an integer, but not decimal values. I think you could try the formula Randbetween(100,1899)/1000 to get a similar effect.

    • @gdmt
      @gdmt 3 місяці тому +1

      @@officenifty Actually, i used the GUI random from the Format > Cell menu to specify the values i need since its got a min max input box. Thank you this, regardless!

    • @officenifty
      @officenifty  3 місяці тому

      @@gdmt Oh yeah, I totally forgot about the Random Number Generator dialog. Thanks for mentioning what worked! Your feedback can help me improve the channel.

    • @gdmt
      @gdmt 3 місяці тому +1

      @@officenifty Anytime man! Keep up the fantastic work!

  • @foxwell1000
    @foxwell1000 Рік тому +1

    RANDBETWEEN IS GIVING ERR PLEASE HELP

    • @officenifty
      @officenifty  3 місяці тому

      What were the values you used for RandBetween()? Can you please try RandBetween(1,100) and see if that gives you a number?