I hope this isn't a second posting of this. 1st one said not logged in.
I want to compare two columns of information with two other columns of supposedly the same information to determine where/if they differ
I've used the "If" function to compare two columns of information row by row with the formula =if(A3=A6,"Y","N") in cell C3.
Can you advise how to modify the formula to compare two columns with two other columns such as =if(A3=A6 & A4=A7,"Y","N") I know that doesn't work
I 'm sure there's a more efficient way but that's my level at present.
Thanks for any help
Bookmarks