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.
Avoid merged cells at all costs, they cause nothing but problems
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
One thing is for sure, we can't solve problems we can't see. Read the yellow banner (top) and post a SMALL sample sheet.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks