Comparison of Excel files
5 USD
1 . Take each item from Table 1 and see if it is in Table 2.
If not, select it red in Table 1.
If so, see if the price has changed.
If not, do not do anything.
If so, select it yellow in the table.
2nd Take item1 from table2 and see if it is in table 1.
If so, don’t do anything.
If not, select it to the green in Table 2.
Есть 2 файла Excel - прайсы поставщика за прошлую неделю (таблица1) и текущую (таблица2). Нужно сделать обработку, которая будет их сравнивать по следующему алгоритму:
1. Возьми каждый товар из таблицы1 и посмотри, есть ли он в таблице 2.
- Если нет, то выдели его красным в таблице1
- Если да, то посмотри, изменилась ли его цена
- Если нет, то не делай ничего.
- Если да, то выдели ее желтым в таблице2
2. Возьми товар1 из таблицы2 и посмотри, есть ли он в таблице 1.
- Если да, то не делай ничего.
- Если нет, то выдели его зеленым в таблице2
Applications 2
Client's feedback on cooperation with Oleksandr Grib
Comparison of Excel filesEverything is fast, quality and cheap.
Freelancer's feedback on cooperation with Anton Lobanov
Comparison of Excel filesA clear and clearly formulated task. A pleasant work. Thank you for cooperation.
-
2 days14 USD
2597 230 0 1 2 days14 USD
Good morning, I will write a program that will process the prizes according to the required requirements.
Доброго дня, напишу програму, яка буде обробляти прайси згідно наданих вимог.
-
Winning proposal1 day5 USD
227 19 1 1 Winning proposal1 day5 USD
Good day . Write a macro to compare files according to the task
Добрий день. Напишу макрос для порівняння файлів згідно завдання
Current freelance projects in the category Databases & SQL
WP + 1C BASTechnical problems are described in the file, I am interested in the timeline and price for the solution, please respond if you know the solution for sure PHP, Databases & SQL ∙ 5 hours 46 minutes ago |
Help with Excel, excell, Google Sheets.
17 USD
Good health, I need help with Excel. I have attached the picture below. The essence: the driver has to fill in the table, he will fill in the data from D2 to G7. Task: 1. In cell A1, put the months. 2. In cell A2, put the days. Goal: So that when the day changes, the table is… Databases & SQL ∙ 9 hours 4 minutes ago ∙ 7 proposals |
Experienced PHP programmer for long-term collaboration
97 USD
Looking for an experienced PHP programmer capable of understanding foreign code for remote support of a script Support includes uploading the script to the server, debugging, and fixing minor errors if they arise The script is debugged and does not require daily work with it,… PHP, Databases & SQL ∙ 1 day 14 hours ago ∙ 27 proposals |
Transfer of the website to Reboot and JournalX themesHello. A person is needed who has thoroughly understood the topics Reboot and JournalX, as well as has knowledge in transferring editing, database automation on WordPress. 1. It is necessary to transfer the existing project https://happybirthdaycardz.com/ from the old theme… Databases & SQL, Data Processing ∙ 1 day 17 hours ago |
Connecting Power BI to My SQL database and creating a reportIt is necessary to connect Power BI to the My SQL database of the accounting system and create a financial report. The accounting system delopro/ PHP, Databases & SQL ∙ 1 day 18 hours ago ∙ 2 proposals |
Zaporozhe