Excel Formula to Find Duplicate Value

Question

I have an excel file with three columns (C,D,E) and one more (F) for finding all duplicate value. How can i use excel formula to get expected result (column F).

So the above columns should look like this:

Thank you in advance!

Answer 1

Try this formula in D2 cell and this is one way to get the output.

=IF(ISERROR(MATCH($A2,$B:$B,0)*MATCH($A2,$C:$C,0)),"",$A2)