LinkBack URL
About LinkBacks
If you have data in columns A and B, how do you automatically remove the data in column A that exists in column B?
How do you automatically remove this data?
If you have data in columns A and B, how do you automatically remove the data in column A that exists in column B?
Use COUNTIF in column C then Filter C column with TRUE, then Delete data in column A
Untitled.png
Quang PT
Hi, welcome to the forum
If you really want to REMOVE data - delete it completely - that cannot be done with formulas, you will need VBA (code) for that, or do it manually (which bebo did)
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks