Share via

Remove Duplicates not working

Anonymous
2017-04-26T16:56:13+00:00

Remove Duplicates is not working for me. Even when I directly Copy/Paste values from one column to another, I get the message "No duplicate values found." This occurs with or without headers. I've tried this on existing workbooks, new workbooks, saved and unsaved workbooks. Conditional Formatting works without fail.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2017-04-26T18:17:57+00:00

    You don't have any duplicates - a duplicate is defined as the same value in every column of the row.

    If you want to remove individual cells that are duplicated, then you could copy the entirety of column Two below column One, and then use remove duplicates based on that single column.  You could move the Two Values back into column B when you are done.

    If you were to remove duplicates from the entire table based on just column A, you would be left with one row of data.

    43 people found this answer helpful.
    0 comments