Hi, i want to check equal condition in column A and D. There is merged cell may be in column A.if logical test match then print "retain" otherwise print "delete row"
I done this unmerged cell with formula: if(D2=A2,"retain","delete row") but facing problem with merged cell in column A.
Column A have may be merged cell.Column D all ce
Cells are unmerged in my data.