PDA

View Full Version : Solved: Duplicates 2



drums4monty
12-09-2008, 07:00 AM
Hi

I have a spreadsheet with Columns A - F. I need to check Col C which is full of Surnames and if the name is repeated under each other I would like to put the word OK in Col F for both of the names. This only needs to happen if the repeated names are adjacent to each other. If the name is repeated a few rows further down then this should not count.

Is this possible?

Bob Phillips
12-09-2008, 07:12 AM
In F2
=IF(AND(C2<>"",OR(C2=C1,C2=C3)),"OK","")

and copy down

mdmackillop
12-09-2008, 11:01 AM
or
=IF(COUNTIF(C1:C3,C2)>1,"OK","")

drums4monty
12-09-2008, 04:40 PM
Thanks guys, both solutions work great, many thanks.

Alan