Hi All,
I need to check for duplicate values in excel and need to update for the respective row as as duplicate,
am able to achieve it using the excel formula .which is mentioned in yellow
problem in on the highlighted one with red - here we have the duplicate entries in column A&C(12,13,14) where in B(12,13) are same but B14 is different
with the formula i have its updating the column D(12,13) as duplicate which is correct but as per busines logic , even the column A,B,C items matches and it has the combination of 2 towl and 1 bath it should not update as duplicate
Excel formula used : =IF(COUNTIFS(A:A,A3,C:C,C3,B:B,B3)>1,“Duplicate”," ")
Any idea pls