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.