All other arguments are left to their default values, meaning the list will start at 1 and will be incremented by 1. In the above formula, you only define how many rows to fill. If you need a classic random number generator with no repeats, then please check out other examples that follow below. Where n is the number of random values you want to get.įor example, to create a list of 5 random numbers, use 5 for n:Įnter the formula in the topmost cell, press the Enter key, and the results will spill automatically over the specified number of cells.Īs you can see in the screenshot below, this formula actually sorts numbers from 1 to 5 in random order.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |