|
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? |
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? |
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 |
| All times are GMT +1. The time now is 03:06 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com