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.