To find Duplicated Entries in Excel
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.
Software
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.
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
by dzlmonze
by dzlmonze
This discussion is closed to new replies.
Sort by Trending