We help IT Professionals succeed at work.

SharePoint Duplicate Records

Medium Priority
196 Views
Last Modified: 2017-07-31
I have a SharePoint 2010 list with a field name of opportunityID and need to find a way to list all records where there could be duplicates
Comment
Watch Question

Walter CurtisSharePoint AED
CERTIFIED EXPERT
Distinguished Expert 2019

Commented:
Not sure of the circumstances totally, but one way to quickly this may be to export to excel and use excel to work with the data, for example find duplicates.

In SharePoint, you could sort by columns to help find duplicates.

Hope that helps...
IsaacSharePoint Client Side Developer

Commented:
Why don't you try grouping by the column with possible duplicates?
It will group by the duplicates.
Walter CurtisSharePoint AED
CERTIFIED EXPERT
Distinguished Expert 2019

Commented:
Any luck?
Matt PinkstonEnterprise Architect

Author

Commented:
not really, what I ended up doing was deleting all records and creating again
IsaacSharePoint Client Side Developer

Commented:
I'm glad you found a solution.
Matt PinkstonEnterprise Architect

Author

Commented:
used own solution

Explore More ContentExplore courses, solutions, and other research materials related to this topic.