Share via

Removing Duplicate ID's

Anonymous
2020-01-03T18:12:28+00:00

I have a spreadsheet with approximately 1,500 unique ID codes.  I used conditional formatting to identify duplicates, but when I select remove duplicates, it says there are no duplicates found.  There are plenty of them, and I would like for it identify the unique ID code and the number of them found, and remove the additional.  Why is it not allowing me to do this?

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
    2020-01-03T18:20:40+00:00

    Do you have only one column of data? Remove duplicates looks at entire rows of your table by default, so you should either make sure that you are having it only look at the single column of IDs,

    Was this answer helpful?

    0 comments