Create a macro for Excel and Google Sheets.
13 USD - one and the same campaign (the campaign name in the column L (Campaign Name (Informational Only));
- for the lines where the value of the column B (Entity) = Product Targeting and Keyword;
- in the column AO (Placement) = placementProductPage, therefore the Percentage values are transferred to the cell, to the column AK (Product Page), the line with B(Entity) = Product Targeting and/or Keyword;
- in the column AO (Placement) = placementTop, therefore the Percentage values are transferred to the cell, to the column AJ (Top of Search), a line with B(Entity) = Product Targeting and/or Keyword;
Note: With a large data volume, Excel processes information very slowly, so the goal of the task is to optimize the time for the processing of a large data volume.The data is downloaded weekly, without columns (AJ (Top of Search), AK (Product Page)).Formats and information are formed automatically by Amazon.HTTPS://www.loom.com/share/b2aa2513959c47dd99c57bc4b6a29c70
Корректная ссылка на видео https://www.loom.com/share/c0bc8f6e992b4f959ef8f248dbf1221f
Applications 1
Client's review of cooperation with Elena St
Create a macro for Excel and Google Sheets.Great work! Congratulated with collaboration!
Freelancer's review of cooperation with Vitaly Lunko
Create a macro for Excel and Google Sheets.Interesting task, productive communication, quick check and payment. Everything is fine, I recommend cooperation.
-
1 day18 USD
3668 107 0 1 day18 USD
After watching the new video, the questions became even more...
It would be good for you to record a new video and all the actions that the macros should do were done by hands on the example of several companies.
-
3 days13 USD
157 1 0 3 days13 USD
Good day
Ready to perform your project in Python (Pandas).
It requires a clear TZ that needs to be done.
Following the proposal on Google Colab
-
1 day22 USD
2870 72 0 1 day22 USD
Slowly - because the formulas with large volumes are long counted. It should be processed in a macro (software). The user selects the file for processing (in the system window of file selection) - and after seconds the result is ready. The data is either added to the table, or a new book is formed (which is better?). Plus user-frendly - the end of the week, the notification :)
Experience since 2011
-
1 day13 USD
137 1 0 1 day13 USD
I have more than 10 years of experience in Excel, I will do everything quickly and quality.
-
1 day18 USD
928 14 0 1 day18 USD
Good morning Vitaly
I will solve this task in Excel.
Go to turn.
-
Доброго времени суток, выполнение рассматриваете только в екселе? Или гугл таблицы тоже?
-
Vitaly Lunko Bow Tie House
как можете
-
Запитуєте про Excel. а на відео Google-таблиця... Файл з даними буде в книзі Excel?
-
Vitaly Lunko Bow Tie House
так в эксель
Гугл таблиці не витягують стільки даних -
Опис задачі не співпадає з показаним на відео
-
Vitaly Lunko Bow Tie House
Дякую, зараз зміню
-
А насколько большой объем данных??
может есть смыл для ускорения рассмотреть вариант использования python pandas. И еще вопрос куда эти данные идут дальше
-
Vitaly Lunko Bow Tie House
в примере 1 день, всех 60 максимум
-
В прикладі 126423 рядка з даними. Якщо це 1 день, то 126423 * 60 - більше 7 млн, а на листі Excel 1048576 (1 млн)...
Чи це про 60 файлів для обробки? Уточніть, будь ласка
-
такое количество данных корректнее было бы обрабатывать в pandas.
А какой конечный результат?
-
Vitaly Lunko Bow Tie House
Таблица с теми же данными + то что сделает макрос
https://www.loom.com/share/c0bc8f6e992b4f959ef8f248dbf1221f -
В прикладі 126423 рядка з даними. Якщо це 1 день, то 126423 * 60 - більше 7 млн, а на листі Excel 1048576 (1 млн). Уточніть про 60 днів
-
Vitaly Lunko Bow Tie House
так
-
Vitaly Lunko Bow Tie House
Перевірив файл, 180-200 тис максимум рядків зараз
-
Зрозуміло, дякую
-
Vitaly Lunko Bow Tie House
Корректное видео
-
Current freelance projects in the category Databases & SQL
Need a 1C specialist for refinements and development.I am looking for a 1C specialist for freelance collaboration. I am currently working with a contractor who provides support and maintenance for the 1C system. However, due to the contractor's workload, there is a need for prompt execution of additional tasks, improvements, and… Databases & SQL ∙ 48 minutes back ∙ 5 proposals |
Development of Backend core (Python), Telegram FSM engine, and Stripe integrationWe are looking for an experienced Backend Developer (Middle/Senior) to create an independent Headless core for an EdTech product. The system operates on a strict monthly subscription model. The core logic must be completely isolated from the content. All development is conducted… Python, Databases & SQL ∙ 6 hours 58 minutes back ∙ 16 proposals |
Restoring Instagram after a banOn March 3, 2026, my Instagram was blocked due to a violation of rules. I believe there has been some mistake, as the page was personal with photos and videos of my personal trips. I did not post any comments anywhere. I have sent several appeals. I cannot download my files… Databases & SQL, Web Programming ∙ 11 hours 54 minutes back ∙ 4 proposals |
It is necessary to upload products into the corresponding categories and subcategories from SQL files.The site is created on WP. It has a product catalog. Products were uploaded from a PDF file, resulting in a bit of a mess. There are three files with a clear distribution of categories, subcategories, and products in them. In the file PA.sql, categories are numbered, for… Databases & SQL, Web Programming ∙ 15 hours 25 minutes back ∙ 29 proposals |
CRM system for Railway LogisticsCreation of a CRM system for a logistics company mainly focused on rail and road transport, 1) Financial reporting 2) Processing applications 3) Contractors 4) Automatic issuance of invoices and acts upon closure, it is possible to create a simplified system based on 1C below… Databases & SQL, Client Management & CRM ∙ 1 day back ∙ 34 proposals |
Kyiv