Delete row if some columns equal others. HELP
How should I make a code that deletes rows if:
Some value in column B has its symmetric in column B as well AND Column E coincides for both. If TRUE, I want to delete the row with the positive value.
Hope someone can give me a help!
Thanks in advance
I did something like the following but I don't know how to make it ANY row instead of +1 neither how to make it delete the positive B column value row.
Please Login or Register to view this content.
Last edited by JBeaucaire; 07-23-2013 at 11:13 PM. Reason: Added CODE tags, as per Forum Rules. Take a moment to read the Forum Rules in the menu bar above. Thanks.
your code does not seem to get along with the description, attach please a sample file with data and desired result
Last edited by patel45; 07-23-2013 at 06:58 AM.
If solved remember to mark Thread as solved
Thanks for the reply. I know the code doesn't do what I want. I just tried something out and was trying to adapt it
I found another way to do it. I'd like to delete the rows where dateF is the same but dateC is greater (plus the value should be positive)
Duplicate post
http://www.excelforum.com/excel-prog...al-others.html
wher'is desired result ?Originally Posted by lmvmbc
The desired result is in the table on the right
maybe this description is wrong ?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks