Hi, I have two columns I am comparing Column A and Column B. In each row they are may have an X value (marked X) or have no value (Left blank). I have figured out how to compare the cells in two columns and give me a True or False for mismatches. But, now I want to be able to identify from the False ones which ones have a value X in Column B (not Column A just Column B). Could someone tell me a simple way to do that other than manually? I have 500 rows to compare and in the future I will have 1000s at a time.
Thanks!
Bookmarks