Try the link again now.

Heidi wrote:

Hi. I have the same problem and that link doesn't work.

"Michael" wrote:


Hi Novaglory. Try Chip Pearson's site:
http://www.cpearson.com/excel/duplicat.htm. Scroll to the bottom and he has
link for deleting duplicates. HTH

"Novaglory" wrote:


Hello everyone,

I'm looking to delete every rows where one cell (not all cells) has a
duplicate value of another cell within the same column, but in a different
row.
Best case scenario, the formula would select which row to delete based on
whether or not another field in the row displayed a specified value.
I sincerely appreciate any help, Thanks