Hello - I am trying to delete the entire row from a worksheet only if:
Column F is a duplicate AND columnW on the same row is blank...
I'm having a tough time with this one, could anyone please help?
Thank you in advance!
Hello - I am trying to delete the entire row from a worksheet only if:
Column F is a duplicate AND columnW on the same row is blank...
I'm having a tough time with this one, could anyone please help?
Thank you in advance!
If I understood you correctly, you don't need a macro for this.
First sort your entire data, by column F ascending, and second level sort column W ascending (non blank above, blank below).
In a new column, put this formula on row 2 onwards
Now filter on this new column for "delete" and select those rows and delete away.Please Login or Register to view this content.
Last edited by millz; 08-18-2014 at 01:14 PM.
多么想要告诉你 我好喜欢你
Please Login or Register to view this content.
Thanks,
Solus
Please remember the following:
1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.Highlight the code in your post and press the # button in the toolbar.2. Show appreciation to those who have helped you by clicking below their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
"Slow is smooth, smooth is fast."
that's perfect! Thank you Solus and Millz - I would apply the advanced filter, but with an ever-changing worksheet I think the VBA solution is prone to be the more flexible alternative.
Thank you - it works perfectly
Glad to help. Thanks for the rep.
If you are happy with the solution please mark the thread as [SOLVED] using the thread tools at the top.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks