flagging duplicates within same column of data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello and thanks in advance for any response. I am a little rusty with my
excel skills and was wondering if anyone could tell me a quick way to flag
duplicates in the same column of data. I have 4 columns of data and need to
flag say any duplicates within column C. I tried an advanced filter with
checking the unique records only box but wasn't sure what to put in the list
range or criteria range and ended up omitting records in columns A and C
also. I REALLY need some refreshers...
 
Thanks so much for your help...question, I was able to get 2 of the steps to
work; the testing for duplicate entries and tagging of duplicate entries, (I
was playing around testing them all) but couldn't get the (what appears to
be) the most simple one to work; the highlighting duplicate entries...I have
3 columns of data A1:A4823, B1:B4823, and C1:4589 and I just at this point
want to highlight any duplicates just within column C...I followed the
formula for the conditional formatting but no luck =IF(COUNTIF($C:$C,
C2)>1,TRUE,FALSE) I'm sure it's something simple. Thank you!
 
.. want to highlight any duplicates just within column C
Click to expand...
....I followed the formula for the conditional formatting
but no luck =IF(COUNTIF($C:$C, C2)>1,TRUE,FALSE) ..
Click to expand...

Select col C,
then use as the Condition 1,
Formula is: =COUNTIF($C$1:C1,C1)>1
Format to taste and ok out

The above will trigger the cond format in col C's cells
containing duplicates (i.e. 2nd instances, 3rd instances, etc)

Alternatively, we could also flag duplicates in col C
in an adjacent empty col D (say) by putting in D1:
=IF(C1="","",IF(COUNTIF($C$1:C1,C1)>1,"Dup",""))
then just copy D1 down as far as required

Col D will return "Dup" for duplicates found in col C
(Can then use autofilter* on col D to filter out "Dup")
*via: Data > Filter > Autofilter, with a new top row added

---
 
Beautiful! Thanks for the help!
--
sramsey


Max said:
....I followed the formula for the conditional formatting

Select col C,
then use as the Condition 1,
Formula is: =COUNTIF($C$1:C1,C1)>1
Format to taste and ok out

The above will trigger the cond format in col C's cells
containing duplicates (i.e. 2nd instances, 3rd instances, etc)

Alternatively, we could also flag duplicates in col C
in an adjacent empty col D (say) by putting in D1:
=IF(C1="","",IF(COUNTIF($C$1:C1,C1)>1,"Dup",""))
then just copy D1 down as far as required

Col D will return "Dup" for duplicates found in col C
(Can then use autofilter* on col D to filter out "Dup")
*via: Data > Filter > Autofilter, with a new top row added
Click to expand...
 
Back
Top