Work with Excel. Excel Macro
There is an Excel file with data and certain manipulations need to be performed on it. I need to do this periodically.. so I want to automate it.
The conditions are as follows. These are all paints. If the paint has the same car brand, paint code, paint name, and belongs to a certain color group, for example, black effect or red, then two such paints are considered duplicates. One must be kept.
Also, as an option, there can be two completely identical paints, but have different ranges by year of manufacture. In this case, we take the minimum value for the year of manufacture from all paints and the maximum value for the year of manufacture also from all variants. And we keep only one variant with the widest range by year of manufacture.

Applications 1
-
1831 46 3 Hello!
I am interested in your project, I have experience working with VB macros in Excel/Word/PowerPoint;
Contact me to discuss the project details!
-
561 15 0 Good evening! There is an almost ready version. Write to me privately, I will show you how it works.
-
91 Good day! I have experience in sorting information in Excel. I am ready to discuss the details and immediately start working. Feel free to reach out!
-
1134 38 0 I can do it
_______________________________________________
-
2257 35 0 Good day. I will help solve the task considering periodic data updates. I will propose an optimal solution. Feel free to reach out.
-
5894 345 0 I can create a macro that will remove duplicates that meet certain criteria. You will only need to press a button on the sheet...
-
2141 85 0 Ready to do it. _____________________________________________________
-
3008 73 4 2 Good day! I have a lot of experience working with spreadsheets, so I will write the macro quickly, and most importantly - with quality!!!! Feel free to reach out - I can start right now!!
-
4461 102 0 Hello, I will be happy to help. I will complete everything quickly and efficiently! I suggest we discuss all the details.
-
1312 37 0 Good day.
I have experience in writing macros.
Let's discuss the details.
-
165 6 0 Good day! I am interested in your offer, I work with spreadsheets and will try to help you. Please write the details in private.
Current freelance projects in the category Data Processing
Digitization and structuring of official questions from the Traffic RulesLooking for a performer for technical work: transferring the official publicly available database of questions from the Traffic Rules (TR) into a structured Google spreadsheet and organizing accompanying images. Data Source Only the official state source — the Main Service… Information Gathering, Data Processing ∙ 19 hours 19 minutes back ∙ 17 proposals |
Search for manufacturer / contract manufacturing Ukraine
22 USD
Need to find 3 contract manufacturers of dietary supplements in the form of gummy candies in Ukraine or nearby countries (Hungary, Poland), and inquire about the terms of cooperation: - minimum order (price) - price for increased volume - number of functions they can produce?… Marketing Research, Data Processing ∙ 23 hours 49 minutes back ∙ 8 proposals |
Assistance with personal social media, networking, and projects for a monthFor activities in the field of science and scientific publications, I am looking for an assistant to perform basic organizational and operational tasks for a month as an executive assistant. Tasks include, but are not limited to: - working with AI at a deep level with documents… Data Processing, Customer Support ∙ 2 days 21 hours back ∙ 10 proposals |
Database of hotel owners Ukraine
67 USD
Could you please let me know if you can match a database or find hotel owners in Ukraine for lookalike audiences? Perhaps someone has it and what is the price? Thank you Data Processing, Information Gathering ∙ 9 days 22 hours back ∙ 20 proposals |
Analytics Setup
223 USD
We have GTM and Conversion API connected to Meta. Currently, it is not working correctly everywhere. We need to fix the issues and further develop the amount of analytics on the product. Data Processing ∙ 10 days 15 hours back ∙ 18 proposals |