Cols A, B, C have values. I want to find each row where the values are the same. Example if A1 and B1 and C1 match A2 and B2 and C2 then it's a match, if any of these values is diff then it's not.
So I created a helper column in col D. Have to find when it's a match. Unfortunately this is a protected worksheet and one of the things I cant do is use conditional formatting.
Soo how do I know if any value in Col D is a duplicate or not?
So I created a helper column in col D. Have to find when it's a match. Unfortunately this is a protected worksheet and one of the things I cant do is use conditional formatting.
Soo how do I know if any value in Col D is a duplicate or not?