duplicates

[johnfli]

I have a sheet that has had data imported into it.


CAXU9605980
CAXU9661520
CAXU9816262
CAXU9974231
CAXU9974308
CLHU4489864
CLHU4489910
CLHU4490649
CLHU4528282
CLHU4529566
EMCU1171480
CLHU4489910
EMCU2256370
EMCU2405957
EMCU9220723
EMCU9417353
FSCU6292526
CAXU9605980



The following list above is all in Column 'B'
There will be duplicates of these numbers
I need to have a macro that will delete teh rows of the duplicates.

How can I do that?

Thanks

 

[Ron de Bruin]

Hi John

http://www.cpearson.com/excel/deleting.htm#DeleteDuplicateRows

Or you can use Advanced filter
http://www.contextures.com/xladvfilter01.html#FilterUR

 

[Gord Dibben]

johnfli

You want to get rid of the duplicates, but keep one each of everything.
Right?

Several methods which do not involve macros.

See Debra Dalgleish's info on using the Advanced Filter for returning unique
entries.

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

Also Chip Pearson's site for removing, tagging, highlighting and more.

http://www.cpearson.com/excel/duplicat.htm

Gord Dibben Excel MVP