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.

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.

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.

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.

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.