Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Need Help In Deleting Duplicate Items in Excel a excel file

  Asked By: Jason    Date: Nov 08    Category: MS Office    Views: 1264
  

I am new to Excel macro life , I am facing one problem in deleting duplicate
items in a excel file,
I have two columns but like

column 1..............column 2
Ahmad.............. Kamal
Ahmad.............. Kamal
Tariq............. . Kamal
Saleem.......... Kamal
Alif............ Kamal
Arab.................... Madina

now I do want to keep at least one row of Ahmad Kamal. I don't want it to
seperate the two columns as they are correlated to one another. and I don't want
it to delete the row with Tariq in it either. basically it would call for a look
in column 1 to see if it's a duplicate if it is and the name in column 2 is a
duplicate as well then it is to delete all but one copy of the name.


column 1..............column 2
Ahmad...........Kamal
Tariq..................Kamal
Saleem............Kamal
Alif.................. Kamal
Arab.................... Madina

If someone has solution to this, please let me know.

Share: 

 

No Answers Found. Be the First, To Post Answer.

 




Tagged: