Thread: Macro to Delete multiple/duplicated lines
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Donald Guillett Donald Guillett is offline
external usenet poster
  
Posts: 36
Default Macro to Delete multiple/duplicated lines
On Feb 21, 6:26*pm, missy wrote:
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 dataadvanced filterunique
Reply With QuoteReply With Quote