General discussion

Locked

To find Duplicated Entries in Excel

By dzlmonze ·
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.

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

To find Duplicated Entries in Excel

by DKlippert In reply to To find Duplicated Entri ...

Look at:

www.cpearson.com/excel/duplicat.htm

Collapse -

To find Duplicated Entries in Excel

by dzlmonze In reply to To find Duplicated Entri ...

The question was auto-closed by TechRepublic

Collapse -

To find Duplicated Entries in Excel

by XBoss In reply to To find Duplicated Entri ...

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

Collapse -

To find Duplicated Entries in Excel

by dzlmonze In reply to To find Duplicated Entri ...

The question was auto-closed by TechRepublic

Collapse -

To find Duplicated Entries in Excel

by dzlmonze In reply to To find Duplicated Entri ...

This question was auto closed due to inactivity

Back to Software Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums