Hello
I have the following A and B columns to compare and obtain the folowing value on C
I am struggling to make the formula to replicate the 4 options for column C when i compare A and B. Empty space means empty cell.Please Login or Register to view this content.
I have the following already but wont do all the values =IF(A1=B1,IF(A1="",2,1),0)
Can you help?
Thanks Xav
Bookmarks