Forum Discussion
Sorting problems
Hello Microsoft community, I am working off of several different lists of names. I need to just show the duplicate names so that I can remove them from the dbase of names. The conditional formatti...
Conditional Formatting (CF) does NOT remove duplicates. It just highlights them. If you want to create a list of the duplicate names, you could use CF to find and highlight them with a color.
Then, filter the column by that color to create a list of only the duplicate names
Copy/paste values, transform to a Table.
On the Data ribbon, choose Remove Duplicates to end up with a list of Names that were duplicated in the original list.
Or, just create a Pivot Table, counting the Names in the original list. Show only Names with a count greater than 1.
Or, use PowerQuery. First Keep Rows / Keep Duplicates. Then, Remove Rows / Remove Duplicates.