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)