The low tech solution is to click n the column with the count, twice so that the duplicates float to the top and then save the report. Of course that leaves the bottom of the report all "1's" ie the records which are not duplicates.
Detecting duplicates can be done with a formula query but the syntax for that is more complex and depending on the number of records in your table it may be too many records for the formula query to handle. Out of curiosity how many records are in the table?
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------