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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to Delete Duplicate Cells 2
Delete duplicates based on time 2
Deleting Duplicate Rows 12
Help with pseudocode translated into VBA Code 1
Delete Entire Row for duplicate values in selected column 2
Excel 2007: Delete Duplicates 2
Counting and deleting duplicate rows 0
Deleting Duplicate with a Msg box which displays no of duplicates 7

Back
Top