Thread: Macro to Delete multiple/duplicated lines
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
missy[_2_] missy[_2_] is offline
external usenet poster
  
Posts: 2
Default Macro to Delete multiple/duplicated lines
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?
Reply With QuoteReply With Quote