How to remove duplicate record

K

Kyle

I have excel spread sheet containing Item Number and
desrcription. I found out that user been creating
duplicate Item number. How do I find and delete the
duplicate one and keep one. I need a way to do at once
instead of searching one by one.

Thanks.
 
A

Alan

If both columns have been duplicated, Advance Filter > Unique Items will do
it, if however the Item Number is duplicated but the description is
different so you have two items with different descriptions then you could
try this
With the Item Numbers in A2:A100 and the Description in B2:B100, in C2:C100
enter
=IF(COUNTIF(A2:A100,A2)>1,"Duplicate","") and copy down to C100
Sort A2:C100 by column C and all the duplicates will be in one place so you
can delete what you need to,
Regards,
 
G

goss

Kyle said:
I have excel spread sheet containing Item Number and
desrcription. I found out that user been creating
duplicate Item number. How do I find and delete the
duplicate one and keep one. I need a way to do at once
instead of searching one by one.

Thanks.
Click to expand...

Kyle -
See Chip Pearson's website
http://www.cpearson.com/excel.htm
"Deleting Duplicate Entries"

Highlight the code
In XL, create a workbook named personal
Save personal.xls to c:\program files\microsoft office\office 11\xlstart\
Then the macro will be avail anytime you use XL

Highlight the list to be analyzed
[alt] + [f8] on your keyboard
Choose the Delete Dupes macro
Voila!!

HTH
-goss
 
Top