How to remove duplicate record

[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.

 

[Gord Dibben]

Kyle

Dta>Filter>Advanced Filter.

Check "unique records only" and "copy to another location".

For more on this see Debra Dalgleish's site.

http://www.contextures.on.ca/xladvfilter01.html#FilterUR

Gord Dibben Excel MVP

 

[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,

 

[Jim May]

see http://www.cpearson.com/excel/duplicat.htm#TaggingDuplicates

 

[goss]

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.

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