Data processing in Excel file
There are 42 thousand items of the Excel file in one column.
In the other column to each item is the name of the series/collection of goods.
In the third column you need to get all the item through the point with the back that belongs to that series/collection, but not having the item that is indicated in the main column.
I add an example photo.
Ideally - get a finished file and the mechanism of performing that data processing (a macro or formula with which it can be done quickly).
Or just a finished file.
Applications 1
Client's review of cooperation with Mykola Y.
Data processing in Excel fileThe task was done quickly and efficiently, I recommend this freelancer.
Freelancer's review of cooperation with Vladimir Vysotsky
Data processing in Excel fileThe customer is good, I recommend it to everyone.
-
345 22 0 Hello to you. Ready to perform the task. I will be happy to cooperate. turn to
-
176 17 0 Hello to you.
Ready to take the task.
Write in the face, we will discuss details.
-
2864 72 0 from VBA since 2011. Additional options (on choice or all in one basket): remove the remaining rows-double; automatically form a new book with clear data; a macro processor not only for one table.
A half hour and a half hour, and you can get the result.
-
755 72 0 Good day . I'll write a macro under the exel that will do it perfectly!
I write in a clear and correct code - look at my reviews. The price is adequate, you want cheaper - test on the deletes. I will not praise anymore.
Good day to you.
-
812 15 0 There is a ready solution, adding a feature through VBA, there will be a new feature in the book that will do it. But you have to try on your volumes (42000), turn.
-
928 14 0 Good day .
I will solve your task within 1-2 hours, automating for future similar tasks.
-
419 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.
-
1134 38 0 Good day . I can do that ideally. It will work when adding / deleting data
-
145 1 0 I can do. I also provide formulas and algorithms of work with data.
Current freelance projects in the category Data Processing
Building financial models (P&L + Cash Flow)We are looking for a qualified specialist who can help organize our business finances. We need to develop and implement two key reporting forms: P&L (profit and loss statement) and Cash Flow (cash flow statement). Please provide your work experience, what you have worked on,… Accounting Services, Data Processing ∙ 2 days 6 hours back ∙ 17 proposals |
Assistant to the manager for project work in the field of science and scientific publicationsLooking for a responsible assistant to work with personal social networks, a contact database, and current projects in the field of science and scientific publications. At the first stage, the collaboration is planned for one month. The main task is to assist with basic… Information Gathering, Data Processing ∙ 2 days 21 hours back ∙ 10 proposals |
Contacts of the Northern European countries
28 USD
Hello everyone I need to find contacts of companies (Cleaning Company) that are engaged in cleaning in one of the niche industries - shipping. These companies deal with cleaning ships of various purposes, - cargo ships (only cleaning of ships) and the service is called - cargo… Data Processing, Information Gathering ∙ 4 days 21 hours back ∙ 21 proposals |
Search for contacts_Southern Europe (Greece, Italy, Spain, and France (south and north of the country))
22 USD
Hello everyone I need to find contacts of companies (Cleaning Company) that are engaged in cleaning in one of the niche industries - shipping. These companies deal with cleaning ships of various purposes, - cargo ships (only cleaning of ships) and the service is called - cargo… Data Processing, Information Gathering ∙ 4 days 21 hours back ∙ 19 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 ∙ 7 days 7 hours back ∙ 13 proposals |