Getting random numbers

If you want to get random numbers between two numbers, you use RANDBETWEEN() function. First, you write the bottom number, secondly you write top number. 

If you use more RANDBETWEEN() function in a datasheet, in each enter click, all RANDBETWEEN() functions work again.

Moreover, when a new formula is entered, all RANDBETWEEN() functions find a new number again.

 If you want to write the chosen number more times, you use REPT() function with RANDBETWEEN() function as you see in example.

Related Trainings

Badly Formatted Data

Badly Formatted Data

Cleaning up data using various text functions which were given below. You will also correct some datas in the table.


Text Formulas – REPT() & LEN() for adding leading zeroes before incomplete Cheque Nos.

Text Formulas – REPT() & LEN() for adding leading zeroes before incomplete Cheque Nos.


Travel Budget

Travel Budget

Create a "Travel Budged" sample.