Macro to Delete multiple/duplicated lines

[missy]

Hi,

Please help, how do I delete duplication in a column?

For example: Column A has the following data

SL553
SL553
SK123
SK123
CV222
CV222

How do I only keep SL553, SK123, SV222 and delete its duplication?

 

[Jim Cone]

That could depend on the Excel version you are using.


"missy" <[email protected]>
wrote in message
news:1ce87e24-2252-4837-915e-1646c1c5a0cf@q40g2000prh.googlegroups.com...

 

[Donald Guillett]

Hi,

Please help, how do I delete duplication in a column?

For example: Column A has the following data

SL553
SL553
SK123
SK123
CV222
CV222

How do I only keep SL553, SK123, SV222 and delete its duplication?

Assuming proper sorting, a looping comparing the rows and delete from
the bottom up. Or, make a unique list with data>advanced filter>unique