Working with the Excel Base
There are two bases, the old and the new, in each 25 areas.
Needed to:
1) gather all in one file the "Work Result" axle, leaving only the necessary columns
2) Remove contacts without mobile numbers
3) bring all mobile numbers to the '+38 format.
4) Remove duplicates with a repeated phone number
5) Gathering data on areas
*The folder is new, there is a Google tab file, it repeats a new base, but mobile numbers are assigned to a separate column.
Client's review of cooperation with Petro Shpak
Working with the Excel BaseWe work for the second time. Everything is done quickly and quality. I recommend !
Freelancer's review of cooperation with Aleksandr Matkovsky
Working with the Excel BaseI recommend it.
The customer responds to the question immediately.
The task was not standard and was interesting.
-
421 13 0 Welcome to!
I work with Excel and Google tables.
Ready to help with a formula or macro (scripts).
I will be happy to cooperate.
-
5894 345 0 I can gather, bring, remove, lose.
There are nuances that require clarification.
Duration of stock
-
637 8 0 Good Morning, Alexis
ready to get to work, has great experience working with Exel
Current freelance projects in the category Databases & SQL
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 ∙ 3 hours 25 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 ∙ 6 hours 56 minutes back ∙ 28 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 ∙ 15 hours 31 minutes back ∙ 33 proposals |
Eliminate the issue of incomplete data import from Excel files of Nova Poshta specifications into 1C:
45 USD
Goal: There is a processing in 1C for uploading the specifications of Nova Poshta. For unclear reasons, it has stopped loading some tabular data. We need to find the reason and eliminate the problem of incomplete data import from Excel files of Nova Poshta specifications into… System & Network Administration, Databases & SQL ∙ 3 days 10 hours back ∙ 16 proposals |
Accounting, planning, and sales system for a mushroom farm
602 USD
Here is the complete, final text of the Technical Assignment (TA). It combines all your requirements: 16 chambers, 20 contractors, a schedule by days, accounting for containers, profitability calculation, and a mandatory division into three grades of mushrooms. You can fully… Databases & SQL, Client Management & CRM ∙ 5 days 14 hours back ∙ 56 proposals |