software

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...
--
sramsey

Hi sramsey

See
www.cpearson.com/excel/duplicat.htm
www.contextures.com/xladvfilter01.html#FilterUR

--
Regards Ron de Bruin
www.rondebruin.nlquot;sramseyquot; gt; wrote in message ...
gt; Hello and thanks in advance for any response. I am a little rusty with my
gt; excel skills and was wondering if anyone could tell me a quick way to flag
gt; duplicates in the same column of data. I have 4 columns of data and need to
gt; flag say any duplicates within column C. I tried an advanced filter with
gt; checking the unique records only box but wasn't sure what to put in the list
gt; range or criteria range and ended up omitting records in columns A and C
gt; also. I REALLY need some refreshers...
gt; --
gt; sramsey
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)gt;1,TRUE,FALSE) I'm sure it's something simple. Thank you!
--
sramseyquot;Ron de Bruinquot; wrote:

gt; Hi sramsey
gt;
gt; See
gt; www.cpearson.com/excel/duplicat.htm
gt; www.contextures.com/xladvfilter01.html#FilterUR
gt;
gt; --
gt; Regards Ron de Bruin
gt; www.rondebruin.nl
gt;
gt;
gt; quot;sramseyquot; gt; wrote in message ...
gt; gt; Hello and thanks in advance for any response. I am a little rusty with my
gt; gt; excel skills and was wondering if anyone could tell me a quick way to flag
gt; gt; duplicates in the same column of data. I have 4 columns of data and need to
gt; gt; flag say any duplicates within column C. I tried an advanced filter with
gt; gt; checking the unique records only box but wasn't sure what to put in the list
gt; gt; range or criteria range and ended up omitting records in columns A and C
gt; gt; also. I REALLY need some refreshers...
gt; gt; --
gt; gt; sramsey
gt;
gt;
gt;

quot;sramseyquot; wrote
gt; .. want to highlight any duplicates just within column C
....I followed the formula for the conditional formatting
gt; but no luck =IF(COUNTIF($C:$C, C2)gt;1,TRUE,FALSE) ..

Select col C,
then use as the Condition 1,
Formula is: =COUNTIF($C$1:C1,C1)gt;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=quot;quot;,quot;quot;,IF(COUNTIF($C$1:C1,C1)gt;1,quot;Dupquot;,quot;quot;))
then just copy D1 down as far as required

Col D will return quot;Dupquot; for duplicates found in col C
(Can then use autofilter* on col D to filter out quot;Dupquot;)
*via: Data gt; Filter gt; Autofilter, with a new top row added
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
Beautiful! Thanks for the help!
--
sramseyquot;Maxquot; wrote:

gt; quot;sramseyquot; wrote
gt; gt; .. want to highlight any duplicates just within column C
gt; ....I followed the formula for the conditional formatting
gt; gt; but no luck =IF(COUNTIF($C:$C, C2)gt;1,TRUE,FALSE) ..
gt;
gt; Select col C,
gt; then use as the Condition 1,
gt; Formula is: =COUNTIF($C$1:C1,C1)gt;1
gt; Format to taste and ok out
gt;
gt; The above will trigger the cond format in col C's cells
gt; containing duplicates (i.e. 2nd instances, 3rd instances, etc)
gt;
gt; Alternatively, we could also flag duplicates in col C
gt; in an adjacent empty col D (say) by putting in D1:
gt; =IF(C1=quot;quot;,quot;quot;,IF(COUNTIF($C$1:C1,C1)gt;1,quot;Dupquot;,quot;quot;))
gt; then just copy D1 down as far as required
gt;
gt; Col D will return quot;Dupquot; for duplicates found in col C
gt; (Can then use autofilter* on col D to filter out quot;Dupquot;)
gt; *via: Data gt; Filter gt; Autofilter, with a new top row added
gt; --
gt; Max
gt; Singapore
gt; savefile.com/projects/236895
gt; xdemechanik
gt; ---
gt;
gt;
gt;

You're welcome !
Thanks for the feedback ..
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
quot;sramseyquot; gt; wrote in message
...
gt; Beautiful! Thanks for the help!
gt; --
gt; sramsey