Most valuable professional
  • 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:

  • Excel
  • Microsoft Excel