PDA

View Full Version : Duplicate values



entwined
08-28-2012, 07:32 PM
Hi troops,

I can find duplicates using conditional formatting but I want to find them and put a remark beside its cell at the same time:

e.g. column A contains all the data and if there is a duplicate value, it should have a remark "Duplicate" in column B.

InputText1
InputText2
InputText3
InputText4
InputText5
InputText6
InputText7
InputText8
InputText9
InputText10
InputText6 Duplicate
InputText9 Duplicate
InputText11
InputText12
InputText10 Duplicate

Any help would be very much appreciated. Thanks...

mikerickson
08-28-2012, 07:44 PM
Try
=IF(COUNTIF($A$1:$A1,A1)>1, "Duplicate", "") in B1 and drag down.