I would like to identify duplicate records in one table

Question

I have a text field titled Building Name and I would like to identify duplicate values in the Building Name field. I also would like to know how many for each - particularly in a summary report. Do I perform this with a formula query? If so , how?

------------------------------
Jason Tommy
------------------------------

prashantmaheshw · Answer

Formula Query is 1 way , &nbsp;Personally I export to excel with RID, highlight in excel and introduce a new field isDuplicate and reimport back. Whole process takes me around 3 min&nbsp;BUT I believe so will formula queryhttps://community.quickbase.com/blogs/ashley-banning/2021/07/26/finding-duplicates-in-qb-just-got-easier------------------------------Prashant Maheshwari------------------------------

Forum Discussion

I would like to identify duplicate records in one table