Editing the database in Excel
There is a ready file of the client and order database
It is necessary to output formulas for:
Clients with more than 3 orders
Clients with more than 5 orders
Clients with a check of more than 5 thousand UAH
Also, sort separately by product
-
I am ready to start now, either manually or through Python code, I will fix everything and do it.
-
337 Hello!
I will finalize your Excel file:
I will add 3 lists of clients:
those who made 3+ orders,
those who made 5+ orders,
those with a check over 5000 UAH.
I will create a separate sheet with a breakdown for each product (how many times purchased, for what amount, etc.)
…
Everything will be automatically updated, with filters and a simple instruction.
-
93 Готова зробити завдання до кінця дня! Гарантую якість та швідкисть
-
280 Good day, I will complete the task in two hours and for the minimum payment.
-
2327 61 0 Hello :) I will complete it quickly and efficiently. The task will take a few hours. Regarding the products - can you make the task more specific?
-
181 Good day, I will complete my experience with databases in a couple of hours!
-
43 Hello, Dmytro!
I am ready to take on this task right now. I have a good command of Excel/Google Sheets formulas (IF, COUNTIF, sorting). I will do everything quickly and clearly: I will write the conditions for selecting clients (number of orders, check > 5000) and sort the database. I am ready to start.
-
940 4 0 Hello.
I can help with this request. And additional tasks related to this case.
-
316 1 0 Hello.
I have extensive experience working with Excel.
Send the technical specifications, I will complete them quickly and efficiently.
-
153 Good day.
I am ready to help with this task.
I definitely need clarifications regarding sorting and preferences for the structure.
-
1026 15 0 Good day.
I am ready to help with this task. We can discuss the details in private messages. I suggest doing this through Power Query, as there is a lot of data in the table and the formula will lag and everything will freeze.
-
4461 102 0 Good evening. I will be happy to help. I will complete everything quickly and efficiently!
-
412 7 0 Good day. I have extensive experience working with Excel. I will complete your task quickly and efficiently. Please contact me, I will be happy to help!
-
718 5 0 Hello.
I have extensive experience in automating various tasks in Excel and Google Sheets. I will be happy to collaborate.
Write to me, I will complete everything promptly and with quality.
Post-project support.
-
228 Good day! My name is Oleksandra. I can complete the task of editing the Excel database efficiently and within the set deadline. I would be happy to assist you with this project.
-
378 85 3 6 Good day, I will do this within a few hours and maybe something more.
-
2578 57 1 1 I work as a financial analyst in a large international company. I will do it today.
-
5852 345 0 I can edit the file in various ways, depending on whether it is a one-time necessity or if you are specifically interested in automating the execution of the described actions.
-
504 5 0 Hello!
I am ready to complete the task: after agreeing with you, I will partially or fully clean the data, standardize it, after which I will correctly count the unique customers and create samples: customers with 3+ orders, 5+ orders, and a check over 5000 UAH.
I will also prepare a separate sorting by products.
-
151 Hello!
I would gladly do anything based on your data.
(This task could also be done by my students...)
I am setting the minimum rate (the functionality does not allow setting less), but additionally, I offer either to teach someone to make similar selections, or to collaborate on a permanent basis, or your proposal.
-
812 15 0 I will do it, we need to discuss the sorting, please contact me.
-
20 Good day. I can do it quickly and efficiently. Write to me, I will be happy to help.
-
492 1 0 Hello. I have professional experience in working with and automating various spreadsheets and reports in Excel. Feel free to contact me, I will help.
-
501 Good day! Based on the provided file with the client and order database, I have prepared formulas for data sampling and analysis.
-
2242 35 0 Good day. I am ready to help quickly complete the task. I will propose an optimal solution if it is necessary to anticipate constant database updates. Feel free to reach out.
-
964 17 0 Good day!
I work professionally with Excel, Google Sheets. I am ready to complete this task, and we will also be able to quickly process new requests/tasks in the future.
-
986 12 1 I am ready to promptly and qualitatively complete your order. I have experience working with similar projects, always adhere to deadlines and technical specifications. I will be happy to collaborate!
-
252 Hello!
I have reviewed your task - everything is completely clear. I can carefully prepare customer samples (>3, >5 orders, check >5000 UAH) and sort the database by product.
I work quickly: I will complete everything in 1-2 hours after confirmation.
I guarantee a clean, neat .xlsx file, ready for further work.
I am ready to start immediately.
-
2211 18 3 Good day. I can do it quickly and efficiently. Write to me, I will be happy to help.
-
542 11 2 2 Hello! I am ready to complete this task. I will write the correct formulas in Excel to automatically output the necessary data. I will also do a separate sorting by products according to your requirements. I can start working right now.
-
deleted by moderator
-
Current freelance projects in the category Data Processing
Conduct 7–10 interviews with owners of mobile service businesses (B2B customer research)Task description:I am looking for a specialist in market research / B2B interviews. It is necessary to communicate (phone or video call, 15–25 minutes) with 7–10 owners of small mobile service businesses in Ukraine — cleaning, plumbing, electrical work, equipment… Information Gathering, Data Processing ∙ 7 hours 46 minutes back ∙ 1 proposal |
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 ∙ 6 days 4 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 ∙ 6 days 20 hours back ∙ 12 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 ∙ 8 days 20 hours back ∙ 22 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 ∙ 8 days 20 hours back ∙ 20 proposals |