In Progress

Need excel formula for find and delete !

We have two XML files. One is source XML file which is coming from provider and second is our own xml which is modified. The source XML file is being updated everyday. This file is being used to import products into an ecommerce website.

Product Codes are main values to identify products. When a new XML file came to us, we need to check deleted prducts from the list and delete same products from our own XML file, and add new products if there is new product codes in the source XML file.

We can find product code differances between two files and able to see which product codes are new and which product codes are deleted.

Lets think that our existing product codes are in A1 column. And deleted product codes are in B1 column. The excel formula we need, must check all values in B1 then search them in A1 and delete. By this way we will be able to delete all products in a fast way.

Please note I just need a formula which can do this search and delete function. I plan to pay 10 USD for this. Please write I AM THE ONE in your bid so I can be sure that you read all requirements.

Thanks.

Skills: Excel, XML

See more: write xml code website, read find write, find code, excel formula find delete, xml excel, find 24, excel us, excel function, excel formula, excel ecommerce, excel list files add, excel modified, xml file excel, need formula, check excel files, read write xml, write file excel, delete function, source function excel, search list excel, find file, excel check, need modified, code delete file, write excel code

About the Employer:
( 4 reviews ) Bakirkoy, Turkey

Project ID: #2511654

2 freelancers are bidding on average $10/hour for this job

vikashgadia

PLEASE SEND US A SAMPLE FILE

$10 USD / hour
(16 Reviews)
3.8
ExpertResearcher

I AM THE ONE

$10 USD / hour
(0 Reviews)
0.0