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

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.

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 ...