Forum Discussion
Formula to ignore blanks
Hi There, I am trying to do a formula of =A1=B1 but to ignore blank cells how do I do this? Code 1 Code 2 Match? 833 834 833 833 833 837 So I woul...
=IF(AND(A2=B2,A2<>"",B2<>""),"Yes","No")
I would enter above formula in cell C2 and copy down.
- You are my saviour - thank you!
