It seems that a few duplicate values (6 or so) are recognized, and the other duplicates are almost like ignored. Thank you, this worked however only for the very small few I mentioned in the original post. so I copied to Notepad, copied the weird space values, replaced the weird spaces with real spaces, moved back to Excel and it worked. The problem was that all of the spaces in Column A (between words etc, such as "Company Inc." weren't actually spaces. I have formatted both as text and removed any extra spaces they may have but Excel will just not highlight them.ĮDIT: Solved. I copied a value from Column B that I saw also existed in Column A to a blank sheet, and Excel can't even detect the duplicates, even though they are right beside each other. To do this, I'm using Conditional Formatting to find duplicate values and highlight them (Conditional Formatting > Highlight Cells Rules > Duplicate Values.), however it sees like 6 companies as duplicates, though I can tell there are hundreds. I'm trying to find which of Column B's values exist in Column A, and separate the rest. I have two columns of data (Column A is about 2,000 rows, Column B is about 1,000).
0 kommentar(er)
