Report showing Duplicate values in a custom field

Content

We have a custom field (orgs.c$accountnumber) that has duplicate values assigned to different customers based on brand and location. I am trying to create a report that shows just the organizations that have multiple organizations with the same account number, and a total number of duplicate accounts. Does anyone have any suggestions on how to do this?

Version

Service Cloud