Fortunately, thanks to Excel’s FILTER() dynamic array function, creating a list of duplicate values is easier than it once was. In this article, I’ll show you how to use FILTER() to create a ...

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.

The lookup function in Excel can save you a lot of time and effort, but only if you actually know how to use its many forms and alterations.

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