# Check for duplicate entries **URL:** \ **Category:** Get Answers\ **Created:** [December 15, 2016, 11:48am UTC](https://forums.knack.com/t/check-for-duplicate-entries/10112 "2016-12-15T11:48:52Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![andrewstee38626](https://avatars.discourse-cdn.com/v4/letter/a/dfb087/32.png) [@andrewstee38626](https://forums.knack.com/u/andrewstee38626)\ **Post date:** [December 15, 2016, 11:48am UTC](https://forums.knack.com/t/check-for-duplicate-entries/10112/1 "2016-12-15T11:48:52Z")
 anyone found a way to check or report on duplicate entries? I have a field text formula that generates a uniques ref but you cant use UNIQUE on a formula ... I cant think of a way of finding them except sorting a table byt this ref and wading through ... anyone any ideas please? thanks Andrew Steele (UK) ---
**Author:** ![SamCarney81930](https://avatars.discourse-cdn.com/v4/letter/s/bbce88/32.png) [@SamCarney81930](https://forums.knack.com/u/SamCarney81930)\ **Post date:** [December 21, 2016, 10:52pm UTC](https://forums.knack.com/t/check-for-duplicate-entries/10112/2 "2016-12-21T22:52:08Z")
You mentioned if they type phone number the same way. Is your phone number field formatted as 'phone number' or text? ---
**Author:** ![andrewstee38626](https://avatars.discourse-cdn.com/v4/letter/a/dfb087/32.png) [@andrewstee38626](https://forums.knack.com/u/andrewstee38626)\ **Post date:** [December 21, 2016, 10:17pm UTC](https://forums.knack.com/t/check-for-duplicate-entries/10112/3 "2016-12-21T22:17:39Z")
Hi Neal, yes that works but means yo have to wade through many pages of tables with a single entry in 99.9% of all groups just to find the ones that have 2 or more in ... thanks though, its a start ---
**Author:** ![andrewstee38626](https://avatars.discourse-cdn.com/v4/letter/a/dfb087/32.png) [@andrewstee38626](https://forums.knack.com/u/andrewstee38626)\ **Post date:** [December 21, 2016, 10:16pm UTC](https://forums.knack.com/t/check-for-duplicate-entries/10112/4 "2016-12-21T22:16:44Z")
Hi Sam, yes thats the only way I can see it working at the moment.  We keep telephone number unique as well, so it checks as you enter, but only if the same number has been sent it and is typed in the same way.  thanks   ---
**Author:** ![SamCarney81930](https://avatars.discourse-cdn.com/v4/letter/s/bbce88/32.png) [@SamCarney81930](https://forums.knack.com/u/SamCarney81930)\ **Post date:** [December 21, 2016, 10:14pm UTC](https://forums.knack.com/t/check-for-duplicate-entries/10112/5 "2016-12-21T22:14:17Z")
I can't think of a good way in Knack, but you could export the table, open with MS Excel, then use conditional formatting to highlight duplicates. ---
**Author:** ![NealPatil52629](https://avatars.discourse-cdn.com/v4/letter/n/3e96dc/32.png) [@NealPatil52629](https://forums.knack.com/u/NealPatil52629)\ **Post date:** [December 20, 2016, 11:06pm UTC](https://forums.knack.com/t/check-for-duplicate-entries/10112/6 "2016-12-20T23:06:13Z")
Idea : Grouping summary on formula field might help. Each unique value of formula field will show corresponding duplicate records. Would you like to update/merge duplicate records to remove duplicates? Following image is from [https://.knack.com/hc/en-us/articles/226584588-Tables](https://support.knack.com/hc/en-us/articles/226584588-Tables) ![](https://tickets.knack.com/hc/user_images/lp-1GiPZpKUzGQtUmy13Rw.png) Neal NealPatil @ gmx.com ---
**Author:** ![andrewstee38626](https://avatars.discourse-cdn.com/v4/letter/a/dfb087/32.png) [@andrewstee38626](https://forums.knack.com/u/andrewstee38626)\ **Post date:** [October 25, 2022, 2:15pm UTC](https://forums.knack.com/t/check-for-duplicate-entries/10112/7 "2022-10-25T14:15:50Z")
As we are in the UK we have to set the type to be free, as there isnt a specific format to suit UK phone numbers ☹