In both columns (A & B), there are a series of "Yes" and "No". Where they match I don't want anything to populate in column C, but where they don't I want an "X" to populate to identify where the disconnects are.
In both columns (A & B), there are a series of "Yes" and "No". Where they match I don't want anything to populate in column C, but where they don't I want an "X" to populate to identify where the disconnects are.
how about simply,
=IF(A1<>B1,"X","")
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
=if(A1=B1,"","X")
I tried both of those previously but I keep getting #NAME? as the result. Any suggestions?
Make sure the "X" is in quotes.
I should have known that, thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks