can I make BOTH duplicates delete automatically?

[thecollectivenet]

Can I make BOTH duplicates delete automatically? Right now they just highlight green, and unique items highlight red. I would like both sets of gren duplicates to delete automatically with every entry, without me having to press a button. Is possible?

[Pete_UK]

You've posted in the Formulas Forum, so I have to say that you cannot do that using a formula, as a formula can't delete cells. You will need a macro instead.

Hope this helps.

Pete