1

I have a long list of companies (3,500+) in a classic SharePoint list. I am trying to identify when there is a duplicate company. Right now I am grouping the Company Name field and scanning through the long list for any groups of more than 1, which is tedious. Is there a way to Sort or Filter to groups of more than 1, so that the duplicates are easier to find?

I've seen this asked a few times but all of the answers are old and don't work with SharePoint designer anymore (at least as the steps are written)

Improve this question
2
  • What type of column is Company Name ?
    – sssreddy
    Commented Jan 24, 2019 at 17:03
  • The Company Name is a single line text column (the title field). As an alternative, we could group on the company's ID # (right now this is a text column as well but could be switched to number if that helps). Thanks!
    – Sarah P
    Commented Jan 24, 2019 at 19:03

2 Answers 2

Reset to default
2

I don't think what you want to do can be achieved in SharePoint online. But it would be very easy to export the list to Excel and create a quick pivot table. Pull company name in the Row panel of the pivot table and again into the Values panel. Then sort by value.

Improve this answer
1
  • Thank you - was really hoping to do this in SharePoint but appreciate the response
    – Sarah P
    Commented Jan 25, 2019 at 14:21
0

There is a workaround for the issue, you could export the list to the excel and find the duplicate items in the excel.

For more detailed information, you could refer to the articles below.

Identifying Duplicate Values in an Excel List.

Find Duplicates.

Improve this answer
1
  • Thank you - was really hoping to do this in SharePoint but appreciate the response
    – Sarah P
    Commented Jan 25, 2019 at 14:21

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.