Microsoft Excel - Comparing and transferring data from two sheets
22 USD There is a large table (950 thousand lines) on one list
There is also a small table (about 100 thousand lines) on the second list.
Both tables have 2 identical columns, as well as the third column that is absent in the main large table.
It is necessary to add values from the third column to the main big table when values from two columns of one sheet coincide with the other sheet.
It is important that the solution works quickly with such a large amount of data. The coincidence can be only 1 for the entire table (if you have added one time to one cell, then you do not need to make a further search)
У нас довольно конфиденциальная база, поэтому будет предоставлено несколько позиций для теста. Мы должны иметь возможность оставшиеся строки добавить сами и провести сверку
Client's review of cooperation with Anton D.
Microsoft Excel - Comparing and transferring data from two sheetsGreat thanks for the help. Everything at the highest level 🙂
Freelancer's review of cooperation with Ivan Petrov
Microsoft Excel - Comparing and transferring data from two sheetsThank you for cooperation. A well-established task. The customer is always in contact and clearly gives answers to the questions arising. Very pleased with cooperation. I advise you freelance.
-
1 day22 USD
1285 30 0 1 day22 USD
Ready to perform. You need a small data set for the test.
You can do both directly in the Excel and make a separate program. Ready to discuss details.
-
1 day21 USD
5531 105 2 1 day21 USD
In a half hour I will give the result on the sample with the formula. Stretch yourself further. I can do it through TeamViewer.
-
1 day22 USD
2088 61 0 1 day22 USD
I can do it with the help of macros, but only tomorrow morning...
-
1 day22 USD
567 28 2 1 day22 USD
What if you divide the main table into several tables (may be by alphabet)? No memory failure.
-
1 day22 USD
3621 113 7 1 1 day22 USD
Good day
The task is clear. I did this
Ready for a short period of time
The accuracy is clear. A few lines will be enough.
-
1 day22 USD
366 25 1 1 day22 USD
Ready to write a program that processes CSV files. I have recently done a project for processing CSV files.
Keep the lists in CSV. Start the program. You get the result.
The development will require the original documents, in which the data, in order to keep confidentiality, should be changed, but the data structure should be left.
-
1 day22 USD
791 26 5 1 day22 USD
Good day . Send the test data to the face, I will set the formulas and you will be able to "extend" them to the entire data mass.
-
1 day22 USD
2162 85 0 1 day22 USD
Готов сделать.
оооооооооооооооооооооооооооооооооооооооооооооооо
-
2 days22 USD
174 6 0 2 days22 USD
Good day . I do it in the form of a program. This is the fastest way to process big tables.
-
1 day22 USD
1015 40 0 1 day22 USD
Ready to make a script on Python + openpyxl + PyQT5 (for graphic interface, if necessary). I can optimize the search as I see the file structure. Go to Ls, we’ll discuss.
-
Winning proposal1 day22 USD
755 72 0 Winning proposal1 day22 USD
the good. I can make a VBA macro. Experience is!! See the portfolio and reviews!
Send me to the file. I will answer within an hour.
The worst day.
-
Сварганили бы какой то короткий пример без конфиденциальных данных, я вот не понял, каким образом сопоставлять две таблицы с разным количеством строк
-
Current freelance projects in the category Desktop Apps
Add pauses of 10-30 seconds between sending emails.
Hello! I am looking for an experienced 1C / BAS (BAF) programmer to promptly resolve a technical issue with email distribution.Problem essence: We use the accounting program BAF (Business Automation Framework), version 2.0. Once a month, there is a need to send about 300 emails… Web Programming, Desktop Apps ∙ 1 day 13 hours back ∙ 9 proposals |
Reverse engineering of console utilities for querying SSD controllers (Flash ID)1. Purpose of the work Extraction of the application programming interface (API) for interaction with SSD/NVMe controllers from the provided set of console utilities (Phison, Silicon Motion, Realtek, Maxiotek, Marvell, JMicron, etc.). The result should be working code in C/C++… C & C++, Desktop Apps ∙ 2 days 1 hour back ∙ 5 proposals |
Modification in the emulator's operation
45 USD
Hello. I downloaded the Gaminator CF Final slot machine emulator from the Internet. I really liked it, but there are some issues. There is an admin panel, but it opens freely and cannot be closed at all. It only closes along with the application. Also, the data does not save… Desktop Apps ∙ 9 days 14 hours back ∙ 10 proposals |
Slovenia