Home |
Search |
Today's Posts |
#1
|
|||
|
|||
problem tagging duplicate entries
good evening,
i'm needing to tag duplicate entries in a single column. the entries were downloaded from access. i'm using the following formula, but keep returning #NAME?. please advise. =IF(COUNTIF(Range1,A1)1,"Duplicate","") |
#2
|
|||
|
|||
If column A contains your data, and is sorted so that duplicates are
displayed together, then in B2 put this formula and copy down........... =IF(A2=A1,"Duplicate","") Vaya con Dios, Chuck, CABGx3 "julz" wrote in message ... good evening, i'm needing to tag duplicate entries in a single column. the entries were downloaded from access. i'm using the following formula, but keep returning #NAME?. please advise. =IF(COUNTIF(Range1,A1)1,"Duplicate","") |
#3
|
|||
|
|||
Works perfect! One more question. If I try to sort on column "b" to bring
all the duplicates to the top, that will obviously mess up the formula, so, can I use another formula to list all the duplicates in say column "c"? "CLR" wrote: If column A contains your data, and is sorted so that duplicates are displayed together, then in B2 put this formula and copy down........... =IF(A2=A1,"Duplicate","") Vaya con Dios, Chuck, CABGx3 "julz" wrote in message ... good evening, i'm needing to tag duplicate entries in a single column. the entries were downloaded from access. i'm using the following formula, but keep returning #NAME?. please advise. =IF(COUNTIF(Range1,A1)1,"Duplicate","") |
#4
|
|||
|
|||
Before you sort, highlight the entire column B and do copy PasteSpecial
Values right back on the same column............this will freeze the values in column B and eliminate the formulas.........then go ahead and sort......... Vaya con Dios, Chuck, CABGx3 "julz" wrote in message ... Works perfect! One more question. If I try to sort on column "b" to bring all the duplicates to the top, that will obviously mess up the formula, so, can I use another formula to list all the duplicates in say column "c"? "CLR" wrote: If column A contains your data, and is sorted so that duplicates are displayed together, then in B2 put this formula and copy down........... =IF(A2=A1,"Duplicate","") Vaya con Dios, Chuck, CABGx3 "julz" wrote in message ... good evening, i'm needing to tag duplicate entries in a single column. the entries were downloaded from access. i'm using the following formula, but keep returning #NAME?. please advise. =IF(COUNTIF(Range1,A1)1,"Duplicate","") |
#5
|
|||
|
|||
I totally should have been able to figure that out... You are the man!!
Thanx Chuck! "CLR" wrote: Before you sort, highlight the entire column B and do copy PasteSpecial Values right back on the same column............this will freeze the values in column B and eliminate the formulas.........then go ahead and sort......... Vaya con Dios, Chuck, CABGx3 "julz" wrote in message ... Works perfect! One more question. If I try to sort on column "b" to bring all the duplicates to the top, that will obviously mess up the formula, so, can I use another formula to list all the duplicates in say column "c"? "CLR" wrote: If column A contains your data, and is sorted so that duplicates are displayed together, then in B2 put this formula and copy down........... =IF(A2=A1,"Duplicate","") Vaya con Dios, Chuck, CABGx3 "julz" wrote in message ... good evening, i'm needing to tag duplicate entries in a single column. the entries were downloaded from access. i'm using the following formula, but keep returning #NAME?. please advise. =IF(COUNTIF(Range1,A1)1,"Duplicate","") |
#6
|
|||
|
|||
You're more than welcome..............happy to help
Vaya con Dios, Chuck, CABGx3 "julz" wrote in message ... I totally should have been able to figure that out... You are the man!! Thanx Chuck! "CLR" wrote: Before you sort, highlight the entire column B and do copy PasteSpecial Values right back on the same column............this will freeze the values in column B and eliminate the formulas.........then go ahead and sort......... Vaya con Dios, Chuck, CABGx3 "julz" wrote in message ... Works perfect! One more question. If I try to sort on column "b" to bring all the duplicates to the top, that will obviously mess up the formula, so, can I use another formula to list all the duplicates in say column "c"? "CLR" wrote: If column A contains your data, and is sorted so that duplicates are displayed together, then in B2 put this formula and copy down........... =IF(A2=A1,"Duplicate","") Vaya con Dios, Chuck, CABGx3 "julz" wrote in message ... good evening, i'm needing to tag duplicate entries in a single column. the entries were downloaded from access. i'm using the following formula, but keep returning #NAME?. please advise. =IF(COUNTIF(Range1,A1)1,"Duplicate","") |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting duplicate entries in an Excel list | Excel Worksheet Functions | |||
Deleting duplicate entries in Excel list | Excel Discussion (Misc queries) | |||
count duplicate (or, inversely, unique) entries, but based on a condition | Excel Worksheet Functions | |||
Preventing Duplicate Entries within a column | Excel Discussion (Misc queries) | |||
Add numbers for duplicate entries then delete | Excel Worksheet Functions |