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.