Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
flagging duplicates within same column of data
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
flagging duplicates within same column of data
Hi sramsey
See http://www.cpearson.com/excel/duplicat.htm http://www.contextures.com/xladvfilter01.html#FilterUR -- Regards Ron de Bruin http://www.rondebruin.nl "sramsey" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
flagging duplicates within same column of data
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! -- sramsey "Ron de Bruin" wrote: Hi sramsey See http://www.cpearson.com/excel/duplicat.htm http://www.contextures.com/xladvfilter01.html#FilterUR -- Regards Ron de Bruin http://www.rondebruin.nl "sramsey" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
flagging duplicates within same column of data
"sramsey" wrote
.. 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) .. 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 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
flagging duplicates within same column of data
Beautiful! Thanks for the help!
-- sramsey "Max" wrote: "sramsey" wrote .. 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) .. 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 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
flagging duplicates within same column of data
You're welcome !
Thanks for the feedback .. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "sramsey" wrote in message ... Beautiful! Thanks for the help! -- sramsey |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
I need more general XY point to point plotting than XY scatter in | Charts and Charting in Excel | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
displaying data within column | Charts and Charting in Excel |