Deleting Duplicates of Second Instance

Home Phone Mobile Phone Ad Response
(999) 999-9999 999-999-9999
(999) 999-9999 999-999-9999
(999) 999-9999 999-999-9999
(999) 999-9999 999-999-9999
(999) 999-9999 999-999-9999
(999) 999-9999 999-999-9999
(999) 999-9999 999-999-9999
(999) 999-9999 (999) 999-9999 999-999-9999
(999) 999-9999 (999) 999-9999 999-999-9999
999) 999-9999 (999) 999-9999 999-999-9999


I organize lectures and I advertise a hotline. Column A and Column B are in my outlook contacts. Column C is a response to an ad or called the hotline. If there are duplicates I want to delete the duplicate that is in column C. Notice that column C is a different format then Column A or Column B.

I did this manually through the find all feature in excel. It was beautiful but very tedious. I would love to have an option to make it more automatic. Would anybody please point me in the right direction.

Thanx so much.