Return value that appears more than once in a row

[davidthomas683070]

Hi, I've got 3 columns of data (Columns 1-3) and I'm wanting to extract a value into a column 4 if it appears more than once in that row. If a row doesn't contain the same value more than once, I don't need a value returning in column 4. Example below which shows the value that should be returned in column 4. If anyone can help it would be much appreciated!

 

[JvdV]

Book1
	A	B	C	D
1	C1	C2	C3	C4
2	Accounting and Finance	Accounting and Finance	Business and Management	Accounting and Finance
3	Art, Design and Fashion	Art, Design and Fashion	Art, Design and Fashion	Art, Design and Fashion
4	Accounting and Finance	Business and Management	Biosciences
5	Aerospace Engineering	Business and Management	Business and Management	Business and Management
6	Business and Management	Accounting and Finance	Business and Management	Business and Management
7	Business and Management	Computer Science	Marketing
Sheet2

Cell Formulas
Range	Formula
D2:D7	D2	=BYROW(A2:C7,LAMBDA(x,@SORT(IF(XMATCH(x,x,,-1)>XMATCH(x,x),x,""),,-1,1)))
Dynamic array formulas.