About random functions. Excel has three random value functions: RAND(), RANDBETWEEN(), and RANDARRAY(). ... to determine how many unique random values to return as an array to the sheet.

So, to fix the random numbers you generated (I used the RAND function in my example below), select the cells containing those ...

As a stand-alone function, UNIQUE() returns 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 to a unique list.

For example, you might want to sort a report involving the partners in your CPA firm according to partner seniority, rather than alphabetically. The RANDARRAY function returns an array of random ...