Unfortunately, there's not currently anything you can do in Quickbase with respect to duplicates. There are new formula functions on the horizon, but we don't have a firm release date on these, so that won't help your current situation. I would suggest pulling the records out of Quickbase into Excel, sorting by the Company Name (assuming this is the field that identifies the record as a Duplicate, and then setting a formula that will look at that field, compare it to the record above and if it's the same, return a 1. I typically label this field "Duplicate" and will create a matching checkbox field in Quickbase. Then, upload the record ID# and the "Duplicate" field back to Quickbase and you'll be able to report and/or delete records based on that field.
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quickbase Solution Provider
Atlanta GA
404.800.1702 /
http://datablender.io/------------------------------