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?