Forum Discussion
Formulas
Hi all, I have a list of names where some recur. I trying to find a formula that will create a list of all the names but without the duplicates. Does this exist? Thanks so much Drew
Hello James. If you have Office 365, Excel has a UNIQUE function. The UNIQUE function will extract a list of distinct values or unique values. Unique are values that occur only once. It sounds like you are looking for distinct, which it handles also. The UNIQUE function is a dynamic array function. Here is a video I created on how to use the function. https://youtu.be/P5QQPvDeFoo If you didn't want to use a function, you could also Copy and Paste and use Remove Duplicates which is on the Data Tab under the group Data Tools. One last thing you could use is a PivotTable and use the Distinct function. Here is a video I created on that feature. https://youtu.be/aPYDMaeLncg
