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