If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Duplicate check
I have a list a names in 2 rows that I am trying to check if any name is
listed more then twice. I can consolidate the names into 1 row if needed but would like to have the result display duplicate or good depending on value. I have tried this with the below formula but it doesnt work. =IF(COUNTIF($B$2:$Q$2,B2)2,"DUPLICATE","GOOD") Thanks. |
#2
|
|||
|
|||
Duplicate check
Duplicate would be greater than 1, right?
=IF(COUNTIF($B$2:$Q$3,B2)1,"DUPLICATE","GOOD") in B4 and copied across, will look for B2 in both rows and return DUPLICATE if count is more than 1... If you want to find duplicates in row 3 then use in B5... =IF(COUNTIF($B$2:$Q$3,B3)1,"DUPLICATE","GOOD") "Robzz" wrote: I have a list a names in 2 rows that I am trying to check if any name is listed more then twice. I can consolidate the names into 1 row if needed but would like to have the result display duplicate or good depending on value. I have tried this with the below formula but it doesnt work. =IF(COUNTIF($B$2:$Q$2,B2)2,"DUPLICATE","GOOD") Thanks. |
#3
|
|||
|
|||
Duplicate check
Its ok for names to show up twice I actually only want it to say duplicate if
the names show up 3 or more times. But can I do this if the list of names are in 2 different rows example: Mon - name1 name1 name2 name2 Tue - name1 name 1 name2 name2 Wed - Thu - Fri - mon -name3 name3 name4 name4 tue - name1 name3 name 4 name4 wed - thu - fri - in the above example Mon is good but Tue has a duplicate. so I am evaluating a total in 2 different rows if that makes any more sense. Thanks "Sheeloo" wrote: Duplicate would be greater than 1, right? =IF(COUNTIF($B$2:$Q$3,B2)1,"DUPLICATE","GOOD") in B4 and copied across, will look for B2 in both rows and return DUPLICATE if count is more than 1... If you want to find duplicates in row 3 then use in B5... =IF(COUNTIF($B$2:$Q$3,B3)1,"DUPLICATE","GOOD") "Robzz" wrote: I have a list a names in 2 rows that I am trying to check if any name is listed more then twice. I can consolidate the names into 1 row if needed but would like to have the result display duplicate or good depending on value. I have tried this with the below formula but it doesnt work. =IF(COUNTIF($B$2:$Q$2,B2)2,"DUPLICATE","GOOD") Thanks. |
#4
|
|||
|
|||
Duplicate check
With the name to test in A1
Try =IF(COUNTIF($B$2:$Q$2,A1)+COUNTIF($B$6:$Q$6,A1)2, "DUPLICATE","GOOD") will check for 'duplicates' in row 2 and 6... "Robzz" wrote: Its ok for names to show up twice I actually only want it to say duplicate if the names show up 3 or more times. But can I do this if the list of names are in 2 different rows example: Mon - name1 name1 name2 name2 Tue - name1 name 1 name2 name2 Wed - Thu - Fri - mon -name3 name3 name4 name4 tue - name1 name3 name 4 name4 wed - thu - fri - in the above example Mon is good but Tue has a duplicate. so I am evaluating a total in 2 different rows if that makes any more sense. Thanks "Sheeloo" wrote: Duplicate would be greater than 1, right? =IF(COUNTIF($B$2:$Q$3,B2)1,"DUPLICATE","GOOD") in B4 and copied across, will look for B2 in both rows and return DUPLICATE if count is more than 1... If you want to find duplicates in row 3 then use in B5... =IF(COUNTIF($B$2:$Q$3,B3)1,"DUPLICATE","GOOD") "Robzz" wrote: I have a list a names in 2 rows that I am trying to check if any name is listed more then twice. I can consolidate the names into 1 row if needed but would like to have the result display duplicate or good depending on value. I have tried this with the below formula but it doesnt work. =IF(COUNTIF($B$2:$Q$2,B2)2,"DUPLICATE","GOOD") Thanks. |
#5
|
|||
|
|||
Duplicate check
IT Doesnt work I think its cause the names I want to test are in all the
cells not just A1. example A1 B1 C1 D1 E1 F1 MON name1 name1 name2 name2 name2 name3 TUE WED THU FRI for MON name2 should set off the duplicate alert, but not name1 if that helps, sorry im trying to explain the best I can, Thanks for your patience "Sheeloo" wrote: With the name to test in A1 Try =IF(COUNTIF($B$2:$Q$2,A1)+COUNTIF($B$6:$Q$6,A1)2, "DUPLICATE","GOOD") will check for 'duplicates' in row 2 and 6... "Robzz" wrote: Its ok for names to show up twice I actually only want it to say duplicate if the names show up 3 or more times. But can I do this if the list of names are in 2 different rows example: Mon - name1 name1 name2 name2 Tue - name1 name 1 name2 name2 Wed - Thu - Fri - mon -name3 name3 name4 name4 tue - name1 name3 name 4 name4 wed - thu - fri - in the above example Mon is good but Tue has a duplicate. so I am evaluating a total in 2 different rows if that makes any more sense. Thanks "Sheeloo" wrote: Duplicate would be greater than 1, right? =IF(COUNTIF($B$2:$Q$3,B2)1,"DUPLICATE","GOOD") in B4 and copied across, will look for B2 in both rows and return DUPLICATE if count is more than 1... If you want to find duplicates in row 3 then use in B5... =IF(COUNTIF($B$2:$Q$3,B3)1,"DUPLICATE","GOOD") "Robzz" wrote: I have a list a names in 2 rows that I am trying to check if any name is listed more then twice. I can consolidate the names into 1 row if needed but would like to have the result display duplicate or good depending on value. I have tried this with the below formula but it doesnt work. =IF(COUNTIF($B$2:$Q$2,B2)2,"DUPLICATE","GOOD") Thanks. |
Thread Tools | |
Display Modes | |
|
|