Hello,
I am comparing two rows cell by cell for exact match. I am having trouble because some cells are blank, however if both are blank, that is a match. Can someone help me with a formula to review that E4=T4, F4=U4, and so on. I am looking for it to say, "Match" if they match and "Review if they do not.
Example
Comparing E4:G4 to T4:V4
E4 F4 G4
Yes Yes
T4 U4 V4
Yes Yes
Bookmarks