Remove Duplicates in columns

Hi,
pls provide me a solution

I want to eliminate duplicate data in a row which has data in columns

like sample columns A,B,C,D and A,B,C has the data of numbers and D is the result of consolidated.

some times A,B,C values can be same so I want to eliminate duplicates and have a unique result

I have done this using "If(AND(" as attached, but I don't think this is the solution
since number of column if increased I have to do again all permutations and combinations

Can I have a Smoother & Easiest way


regards

You could try something like:
=IF(SUM(IF(CONCATENATE(A2,B2,C2)=CONCATENATE(A$2:A$200,B$2:B$200,C$2:C$200),1,0))>1,"Duplicate","")

Hi Mr. Ragulduy, applied your post and answer is blank in every cell since it unsatisfying the given condition and posting the false condition result which is " "

Hi Mr. Richard, it look we need to go for 3 more columns to get the results, do we have any simpler way ?