Hi everyone,
This will hopefully be an easy problem for you guys to solve, but I can't get it to work, so all help is highly appreciated!
The problem:
I have two columns of information (with thousands of rows) and I need to find a way to easily see which rows that has cells which doesn't match each other. I normally just mark the two columns and click "Conditional Formatting" > "Highlight Cells Rules" > "Duplicate Values" > "Duplicate values with light red fill with dark red text" > "OK", then filter out the rows which hasn't been marked.
However, when different cells contain the same information, but on different rows, they still get marked as duplicate, so even if the information in the cells on the same row are different, they get marked as duplicate, just because another cell contains the same information.
I'm not sure if I explained it well enough...so maybe an example will do the trick (two columns below, 9 rows):
1. Excel - Excel
2. Excel - Excel
3. Windows - Paint
4. Paint - Windows
5. Paint - Windows
6. Word - Excel
7. Windows - Notepad
8. Word - Word
9. Word - Word
When I use the duplicate values, it only leaves "Notepad" on row 7 as unmarked, even though I want it to leave row 3,4,5,6 and 7 unmarked, since they don't match. Any ideas how I can do that?
Thank you in advance for the help!
Bookmarks