Hi guys! I am hoping someone has an answer for this, as I am stuck. I have a spreadsheet with two columns. Each column contains a bunch of codes. I need to be able to identify any code that appears in one column, but not the other (doesn't matter which one).
So, if the code appears in column A but not B, I need to know about it.
If the code appears in column B but not A, I need to know about it.
I know this can be done with a formula, but I am not sure what it is! PLease help! Thanks.
Bookmarks