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:

A	B	C	D	E
Date 1	Date 2	Date 4	Date 5	Duplicate Dates?
12/23/2015 10:24	12/24/2015 20:22	12/29/2015 10:16	12/29/2015 10:16	Yes
12/15/2015 11:46	12/16/2015 21:39	12/15/2015 12:59	12/28/2015 2:28	No
12/3/2015 0:18	12/3/2015 0:18	12/3/2015 3:16	12/31/2015 3:52	Yes
12/21/2015 1:07	12/22/2015 19:17		12/28/2015 1:48	No

<tbody>
</tbody>

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!