Discussion Locked

To find Duplicated Entries in Excel

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

How do you Find Duplicated Entries in Excel?
Let us say you have imported Data from Accpac and Colunn A happens to have the Receipts No sorted. You can not do it manually because they are many Entries.

5 replies

by xboss

Try this

1. put this formula in every cell in a column =COUNTIF(A:A,A2)>1.Column A refers to the column with your receipt numbers in it.
2. filter the column for all the "TRUE" answers. These will be the duplicates.
3. Do whatever you need to with the duplicate entries.

Hope this helps

This discussion is closed to new replies.