User Profile
erinlyman
Copper Contributor
Joined Jul 17, 2023
User Widgets
Recent Discussions
Looking for help on conditional formatting.
Hello, I'm hoping someone can help me. I have a very large spreadsheet, i.e. 113316 rows. What I am trying to do is find duplicates, but in multiple columns. I hope I explain this correctly. Column A: Has Internal Part Numbers Column K: Has Supplier Part Numbers Column M: Has Manufacturing Part Numbers A1, K1 and M1 will all be different numbers as the number is based on which company put it in, however, it is all the same product. If K1 matches K2, A1 and M1 should match A2 and M2. I am trying to get a conditional formatting formula set up that will show me when K1 matches K2, but A1 does not match A2 or M1 does not match M2. We are trying to weed out the Internal Part Numbers and Manufacturing Part Numbers that were put into the spreadsheet incorrectly. If anyone has any ideas it would be super helpful. Thank you!781Views0likes1Comment
Recent Blog Articles
No content to show