i have a excel file, see example, ( the actual file may have about 2 k of words)
i want to be able to remove any record if it has any of the keywords found in a raw text file( the actual file may have 10 k of words or phone numbers), see example,
if there is a match of email address or phone number I want it to remove the entire record line, not just the keyword itself
Đã trao cho:
46 freelancer đang chào giá trung bình $58 cho công việc này
We are a team of 2 having vast experience in excel formatting and data extraction. Looking forward to work with you. Thanks !! Please have a look at our message in your PMB
Greetings sir, i am an expert freelancer. for this job and your 100% satisfaction is assured if you allow me to serve, for more info please cheek your message box for this project(Private)
Data analysis and consolidation is one of the core activities of our VBA team. A simple user interface to connect to the txt file and initiate the filtering is included in our solution offering.
Hi, I can do it. What version of excel you use, I will write a macro for the version, IT will work on entire folder if need, not only 1 file. Looking forward to hearing you, Cuong NH
I am a specialist at this type of project. I will remove all records with a match to the keywords in your reference file. I will use automated tools to complete the task quickly with 100% accuracy.