XLS price mixing

Employer
[no-member:pro]Vitaly[/no-member:pro]Vitaly
Project parameters
Type of cooperationOne-time project
SectionSoftware development
Prepaymentwithout prepayment
Payment methodsElectronic money
Acceptance of requestsclosed
Project description
It is necessary to develop a tool for matching the prices of suppliers by the name of the product.
Principle of work:
We download the first XLS price list on the basis of which we will compare the other prices.
The price will contain a column with the item, the name of the goods and the price.
Then we download a few more prices with the same columns.
Task:
The program should combine similar products and issue prices to those suppliers whose names coincide.
Conditions:
- in the output file we must get the article (must be taken from the first price), the name of the product, the prices of suppliers, the minimum price.
The prices of suppliers can be several
Principle of work:
We download the first XLS price list on the basis of which we will compare the other prices.
The price will contain a column with the item, the name of the goods and the price.
Then we download a few more prices with the same columns.
Task:
The program should combine similar products and issue prices to those suppliers whose names coincide.
Conditions:
- in the output file we must get the article (must be taken from the first price), the name of the product, the prices of suppliers, the minimum price.
The prices of suppliers can be several