Sometimes you need a list of unique decimal numbers between 01 and 1 just to try some functions or some features in Excel. There is a very useful Function called RAND. I’ll show you immediately how it works:
Suppose you want to fill this table with random sales between 0 and 1. Start by highlighting all the cells you want to fill.
Type equal RAND with a pair of parenthesis. And CTRL+enter. Look at the results.
These cells will be changing every time we do something in Excel, so it would be better to paste them as values. Highlight them and with right-click drag them a bit to the right and then to the left. From menu select paste them as values.
Okay.So you have different ways to fill a range with random numbers
Thank you very much and waiting for your questions.
If you want to learn how to make amazing Dynamic Excel Charts, Dashboards and Pivot Charts in a few weeks, take our Udemy Course for only $25 !! (original price: $199 - 87% OFF!)