=IF(C4=C3,IF(D4=D3,"DUP",""))


That formula’s not working for me. It’s displaying DUP (duplicate) for every single line. Basically if C4 = C3 is false, goes straight to Dup. Why would that be?

Also how would I say what im trying to say, ie if C4=C3 & D4=D3 then Duplicate? I tried ‘&’ that's not working.