# How to Find Out Duplicate Data

**URL:** <https://www.dynamicsuser.net/t/how-to-find-out-duplicate-data/43594>\
**Category:** Developers Forum\
**Created:** [February 9, 2013, 8:52am UTC](https://www.dynamicsuser.net/t/how-to-find-out-duplicate-data/43594 "2013-02-09T08:52:08Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![palak72525](https://avatars.discourse-cdn.com/v4/letter/p/3ab097/32.png) [@palak72525](https://www.dynamicsuser.net/u/palak72525)\
**Post date:** [February 9, 2013, 8:52am UTC](https://www.dynamicsuser.net/t/how-to-find-out-duplicate-data/43594/1 "2013-02-09T08:52:08Z")

</div>

Hello All,

Table Name Item Unit Measure Entry

I need To find Out incorrect Data means Same ItemNO and Qty per Unit measure and this record should put in report… need urgent Help

Regards

Palak

---

<div class="post-metadata">

**Author:** ![babrown](https://avatars.discourse-cdn.com/v4/letter/b/b782af/32.png) [@babrown](https://www.dynamicsuser.net/u/babrown)\
**Post date:** [February 9, 2013, 1:15pm UTC](https://www.dynamicsuser.net/t/how-to-find-out-duplicate-data/43594/2 "2013-02-09T13:15:48Z")

</div>

What have you tried?

Think about how you would do this if the information was not in NAV. Let’s say it was in a spreadsheet or even just written down on a paper.

---

<div class="post-metadata">

**Author:** ![palak72525](https://avatars.discourse-cdn.com/v4/letter/p/3ab097/32.png) [@palak72525](https://www.dynamicsuser.net/u/palak72525)\
**Post date:** [February 11, 2013, 4:42am UTC](https://www.dynamicsuser.net/t/how-to-find-out-duplicate-data/43594/3 "2013-02-11T04:42:38Z")

</div>

1st i will mark out duplicate Qty per Unit measure’s value should be 1 then after i will seach that in marked record item no is not repeating then i will unmark that record and in the end i will get my result… Marked record…

Please help me to find out this result in nav-2009 r2…

Regards

Palak