Excel tutorials

We can simulate a number generator in Excel using the RANDARRAY function

• Enter the formula in a cell of your choice
• We want to generate 7 numbers
• We want the numbers in 1 row
• We want to generate numbers between 1 and 50
• We want to generate integers only
• Above numbers can be seen in the complete formula below
• =RANDARRAY(1;7;1;50;TRUE)
• Keep in mind that duplicates can occur when using this formula