Hi Bob,

Am Mon, 04 Mar 2013 12:54:07 -0500 schrieb Bob:

But, would like to (automatically) Delete duplicates.
Would also like to highlight the duplicate values first, before doing
any deletions.

Column A has the values that I would like to check for duplications.

select your column A = Conditional Formatting = Formula and as
formula:
=COUNTIF($A$1:A1,A1)1 and choose a color to fill.
Then Filter = Filter by color and delete the wisible rows


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2