Thread: Macro to Delete multiple/duplicated lines
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone[_2_] Jim Cone[_2_] is offline
external usenet poster
  
Posts: 1,549
Default Macro to Delete multiple/duplicated lines
That could depend on the Excel version you are using.


"missy"
wrote in message
...
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