Project translated automatically. Log in or register, to view the original A script that works according to the principle of the VPR function, capable of comparing two files and attributing conformity, the comparison goes through the "Cross" field.They compare two prizes of spare parts, the task- positions from the prize to List1, find the corresponding from the prize to List2.And present the information as on List3 !!The !Please note, now the information on List3 is incompatible, otherwise it has entered values manually, but it is presented as a sample for the presentation of information.The crosses are listed through the point with the back, respectively, we take the first value to the "point with the back" divider from the first cell of the cross field to List1 and seek it match throughout the massive-stage of the cross field from List2, !!The !It is important, we only take into account the "point with the back", then the second value, the same operation, etc.Furthermore, under the condition of coincidences of the values of the cross field, we attribute the correspondence otherwise "Article1-brand1-name1-price1=Article2-brand2-name2-price2" It is very likely that coincidences can be in several brands, in this case "Article1-brand1-name1-price1=Article2-brand2-name2-price2=...............=ArticleN-brandN-nameN-priceN" !!The !Important "Articles1 - Brand1 - Name1 - Price1" is the value of the reference price on List1 !!The !Important "Articles2-brand2-named2-price2=...............=ArticlesN-brandN-namedN-priceN" here the value of the price on List2 Please each additional matching mass to distinguish by a separate color, as on List3.The file in the application can be used to test, the cross field is matched, removed the extra divisors, all the values in the lower register.

Proposals 2

Oleksandr Grib

19 1

Projects 19
Rating -
Rating 227

Budget: 500 UAH Deadline: 1 day

I write a macro to compare the cross field. Details to discuss.

Vladimir Sokolets

Winning proposal

28 2

Projects 25
Rating -
Rating 553

Budget: 500 UAH Deadline: 1 day

Ready to implement the project. It was the same in the car parts. It’s better to connect with Skype Sokolv555.

Current freelance projects in the category Desktop Apps

Need to transfer the site from Webflow to WordPress.

Web Programming 57 proposals 0:38

Not specified
Refinement of the Python program for the new Twitter (X) chat interface.

Python 69 proposals 31 July

Not specified
Refinement of the CRM in 1C: displaying the client's bonus balance

Testing & QA 12 proposals 29 July

Not specified
Setting up multiple Viber accounts on one remote desktop

13 proposals 28 July

Not specified
Light application

PHP 66 proposals 28 July

172 USD

Stanislav Hmyrov
Vladivostok, Russia

Projects 1
Rating -
Rating 57

Vladimir Sokolets

Oleksandr Grib

Vladimir Sokolets

Proposals are currently absent

Current freelance projects in the category Desktop Apps

Need to transfer the site from Webflow to WordPress.

Refinement of the Python program for the new Twitter (X) chat interface.

Refinement of the CRM in 1C: displaying the client's bonus balance

Setting up multiple Viber accounts on one remote desktop

Light application