PDA

View Full Version : Solved: Finding and highlighting duplicate names



owen_1987
09-09-2011, 02:21 AM
Hi all,

I have column A(which has names in) and I have been trying to design something that will find duplicate names in column A. What I need is a searching function that starts at A1 and searches column A, then offsets to the cell below and then search for a duplicate of that name etc etc. If it finds a name that is duplicates highlight the cell in yellow

The problem is the names are variable so I can't use a countif.

Can anyone help me with this please?

Bob Phillips
09-09-2011, 02:40 AM
Select A2 down to the bottom, Use conditional formatting with a formula of

=COUNTIF($A$1:$A2,$A2)>1

owen_1987
09-09-2011, 04:18 AM
thanks very much