0

I have a table consisting of 2 columns name and id. I want to check if there's duplicate id's or not. Is there a solution?

1
  • 1
    When there is only numbers in ID, the records are not too much, you may click a cell then go to Layout tab > Sort, set ID for Sort by and Then by, and then observe if there are duplicates. When the amount of data is large, it's best copy table to Excel, then add a column to use countif function to find duplicate ID. When the number is bigger than 1, there are duplicate ID.
    – Emily
    Aug 19, 2020 at 10:00

1 Answer 1

-1

This article does a good job of covering it.

https://support.microsoft.com/en-us/office/find-and-remove-duplicates-00e35bea-b46a-4d5d-b28e-66a552dc138d

TL;DR:

Click Data > Remove Duplicates, and then Under Columns, check or uncheck the columns where you want to remove the duplicates.

3
  • This is for Excel not Word
    – Wasif
    Aug 16, 2020 at 2:23
  • Sorry, I did not notice the tag. I still recommend this though. Copy the table into Excel or Google Sheets and then back over. The only way to do it with Word is to write a VBA script. extendoffice.com/documents/word/… Aug 16, 2020 at 2:26
  • The code does not work as the OP states, it will remove duplicate rows but not columns. VBA arrays are not flexible, there are not many methods there should be makes it very hard.
    – Wasif
    Aug 16, 2020 at 2:30

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .