Excel has three random value functions: RAND(), RANDBETWEEN ... The difference this time, is that UNIQUE() doesn’t return the array to the sheet. Once UNIQUE() removes duplicates, INDEX ...

How to use the UNIQUE() function to return a count ... a list of unique values using the syntax UNIQUE(array, [by_col], [exactly_once]) The array argument is the Excel range you want to reduce ...

Generating random lists of numbers in Excel ... values from your list of random numbers, it's worth noting that the RAND function is the least likely of the three listed above to return any ...

Whether you’re looking for decimals, whole numbers, or even a custom array of values ... enter `=RAND()` into a cell, and Excel will return a random decimal value. If you need random numbers ...