Macro or Script to delete ROW based on duplicate phone number

[PHOTOMANSCOTT]

Say I have a large CSV file of addresses with phone numbers, and some records might be duplicates. If I sort by the phone number; the duplicate records will appear in sequence... is there a way to HIGHLIGHT or MARK those particular rows for me to visually look at and decide which to delete or not?

Or, maybe the first pass thru the file could check for EXACT or CLOSE TO duplicate rows. And delete all dups except the first.

I am NEW to Excel (on a Mac) and not clear how to use macros.

Thanks for any direction.
Scott

 

[mikerickson]

It sounds like you don't need macros to do what you want.
Put conditional formatting on the column of phone numbers.
If A:A is the column of phone numbers, put this CF formula in A1,
=(1 < COUNTIF(A:A,A1))
and copy it to the other cells in the column.
It will highlight the duplicated phone numbers and sorting will bring them together for your inspection.