formula for reporting blanks and matches in excel
Posted on 2014-03-21
In Excel I use this IF formula to determine a comparison of two adjacent cells first to see if they are blank and second to see if they are the same value (but not blank)
I have this array formula which almost works.
I am not permitted to change the data so I am looking to see if cells are blank (vs 0) and if not blank are they the same.
AK2= John AL2=John should return "Same"
AK2= "" AL2= "" should return BothBlank
however if there is one cell blank and the other one has value it still says both blank.
I think I need to add another argument to return "Mixed" if AK2 <>AL2 however I cant seem to get it right. I believe that <> is excels version of "does not equal".