Macro to Delete multiple/duplicated lines

  • Thread starter Thread starter missy
  • Start date Start date
M

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?
 
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?
Click to expand...

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