Identify duplicates and place an X beside the rows

[maxim642]

Employee	Employee ID	Employee ID 2	Email	Duplicates
John 1	1	1111	j@job.com
John 2	2	2222	l@job.com	x
John 3	333	4444	l@job.com	x
John 4	333	5555		x
John 5		5555	r@job.com	x
John 6			t@job.com
John 7	9	8888

For the "Duplicates" column, I would like the calculation to check columns B:D for any duplications, ignoring blanks. If 1 or more duplications are found, return the value "x".

John 1, in the above, has no duplicates, hence the value is left blank.
John 2 has a duplicated value in the "Email" column, hence the value returned is "x".

 

[JoeMo]

Book1
	A	B	C	D	E
1	Employee	Employee ID	Employee ID 2	Email	Duplicates
2	John 1	1	1111	j@job.com
3	John 2	2	2222	l@job.com	X
4	John 3	333	4444	l@job.com	X
5	John 4	333	5555		X
6	John 5		5555	r@job.com	X
7	John 6			t@job.com
8	John 7	9	8888
Sheet3

Cell Formulas
Range	Formula
E2:E8	E2	=IF(COUNTIF($B$2:$B$8,B2)>1,"X",IF(COUNTIF($C$2:$C$8,C2)>1,"X",IF(COUNTIF($D$2:$D$8,D2)>1,"X","")))

 

[maxim642]

Book1
	A	B	C	D	E
1	Employee	Employee ID	Employee ID 2	Email	Duplicates
2	John 1	1	1111	j@job.com
3	John 2	2	2222	l@job.com	X
4	John 3	333	4444	l@job.com	X
5	John 4	333	5555		X
6	John 5		5555	r@job.com	X
7	John 6			t@job.com
8	John 7	9	8888
Sheet3

Cell Formulas
Range	Formula
E2:E8	E2	=IF(COUNTIF($B$2:$B$8,B2)>1,"X",IF(COUNTIF($C$2:$C$8,C2)>1,"X",IF(COUNTIF($D$2:$D$8,D2)>1,"X","")))

Thank you very much!!

 

[JoeMo]

Thank you very much!!

You are welcome - thanks for the reply.