How to identify duplicate values across one row?

[waveriot]

Hello,

I am trying to figure out a way to have a test column that can flag (i.e. YES or No) if a row has duplicate value across two or more columns like the following:

[TABLE="width: 762"]
<tbody>[TR]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]D[/TD]
[TD="align: center"]E[/TD]
[/TR]
[TR]
[TD="align: center"]Date 1[/TD]
[TD="align: center"]Date 2[/TD]
[TD="align: center"]Date 4[/TD]
[TD="align: center"]Date 5[/TD]
[TD="align: center"]Duplicate Dates?[/TD]
[/TR]
[TR]
[TD="align: center"]12/23/2015 10:24[/TD]
[TD="align: center"]12/24/2015 20:22[/TD]
[TD="align: center"]12/29/2015 10:16[/TD]
[TD="align: center"]12/29/2015 10:16[/TD]
[TD="align: center"]Yes[/TD]
[/TR]
[TR]
[TD="align: center"]12/15/2015 11:46[/TD]
[TD="align: center"]12/16/2015 21:39[/TD]
[TD="align: center"]12/15/2015 12:59[/TD]
[TD="align: center"]12/28/2015 2:28[/TD]
[TD="align: center"]No[/TD]
[/TR]
[TR]
[TD="align: center"]12/3/2015 0:18[/TD]
[TD="align: center"]12/3/2015 0:18[/TD]
[TD="align: center"]12/3/2015 3:16[/TD]
[TD="align: center"]12/31/2015 3:52[/TD]
[TD="align: center"]Yes[/TD]
[/TR]
[TR]
[TD="align: center"]12/21/2015 1:07[/TD]
[TD="align: center"]12/22/2015 19:17[/TD]
[TD="align: center"][/TD]
[TD="align: center"]12/28/2015 1:48[/TD]
[TD="align: center"]No[/TD]
[/TR]
</tbody>[/TABLE]

In this example column E would look at the row range of dates and determine if there is a duplicate value or not.

Can someone help? I keep searching but I only see solutions for duplicates between rows in one column...

Thank you,
David

 

[oldbrewer]

I would tuck away a pivot table and if any date_time scored 2 or more then make the E column "yes"

 

[Marcelo Branco]

Maybe...

Formula in E2 copied down
=IF(MAX(FREQUENCY(A2:D2,A2:D2))>1,"Yes","No")

Hope this helps

M.

 

[waveriot]

Thank you Marcelo, it worked since I am working with numbers / dates not strings!