Phone Numbers Repeated
 

I have a chart in excel that looks like this

Ladd Design Koch Stephanie Ms. 156 Farm Rd.

New Canaan, CT 06840 2039663032 F2039660170

except in excel each piece of data is a different cell so in total i have 9
cells
Co. Name, Last Name, First Name, Title, Address, Town & State, Zip Code,
Phone Number and Fax number. There are about 1700 Rows in total. And there
are many repeats as a lot of the data was copied and pasted from other
sources. My problem is these repeats need to be removed. The repeats are in
the phone numbers, if there is a repeated phone number the entire row must be
removed and if possible replaced with a placeholder. The phone numbers are
in Row H, and right now the list is sorted by phone number so if there is a
repeat it will be right ontop of the other. It will take me way too long to
do this by hand and i'll surely miss some if i do is there a formula or a
macro that can help fix this?

Chip Pearson has lots of ways to work with duplicates at:
http://www.cpearson.com/excel/duplicat.htm

But I'm not sure I'd start by deleting the duplicates. When I have to do stuff
like this, I'd always have to pick some data from each of the duplicate rows
(sometimes the address on the first duplicate should be kept--sometimes the
title was on the third duplicate).



Zip Codes wrote:

I have a chart in excel that looks like this

Ladd Design Koch Stephanie Ms. 156 Farm Rd.

New Canaan, CT 06840 2039663032 F2039660170

except in excel each piece of data is a different cell so in total i have 9
cells
Co. Name, Last Name, First Name, Title, Address, Town & State, Zip Code,
Phone Number and Fax number. There are about 1700 Rows in total. And there
are many repeats as a lot of the data was copied and pasted from other
sources. My problem is these repeats need to be removed. The repeats are in
the phone numbers, if there is a repeated phone number the entire row must be
removed and if possible replaced with a placeholder. The phone numbers are
in Row H, and right now the list is sorted by phone number so if there is a
repeat it will be right ontop of the other. It will take me way too long to
do this by hand and i'll surely miss some if i do is there a formula or a
macro that can help fix this?

--

Dave Peterson