View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Heidi Heidi is offline
external usenet poster
 
Posts: 75
Default Delete Rows based on criteria in excel

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