This is so unbelievable in comparing 2 cells not working. I have tried =A1=O1, EXACTMATCH, COUNTBLANK and a number of other IF statements and none work.
It is super simple what I am trying to do.
Compare 2 cells that may or may not have null values. If the text is identical, give me a "O" else give me an "X".
So if the cells are both null or both exact text matches I want a "O", otherwise an "X".
PLEASE HELP lol....I have been doing this for hours and nothing is working (shouldn't this be easy?) :)