- Hot Topics
Excel Find duplicates numbers in selected columns but delete duplicates in one of those columns
Good morning, I would like to do this with vba I have column A listing phone numbers, I paste new list of phone numbers in columns C, E, and G. I would like to find duplicates in columns A and C, and delete cells in column C, then find duplicates in columns A, C, and E, removing cells only in column E, then find duplicates in columns A, C, E and G, removing cells only from column G. Could someone help me with this? The way I do it now is cumbersome... In the first step, I would conditional format the duplicates, sort column C by cell colour and delete these cells. With none of this automated. I'm hoping someone could help out. Thank you -- g
This question generated 35 answers. To proceed to the answers, click here.
This thread is current as of January 9, 2014.
For more resources for Microsoft Excel:
This article includes the following tags:
- Microsoft Excel