Setting up formulas in Excel
22 USD Good afternoon
there are Excel tables with up to 10 columns
1. need to check the current table for duplicates (based on data from one column)
2. remove or if possible highlight duplicates from this table (if the information in one specific column matches)
2. compare two similar tables for duplicates (based on data from one column)
4. remove duplicates from these tables (can be highlighted)
need help creating the necessary formulas to solve these tasks
Client's review of cooperation with Tetyana Shumeyko
Setting up formulas in ExcelThe task was quite challenging, as it was not initially specified that it should be performed on a MacBook, while the solution was made on Windows. The freelancer demonstrated professionalism and persistence, offering various solution options to adapt the task to the new conditions. As a result, the task was successfully completed. I am grateful for the effort to find a solution and to see the work through to the end, despite the difficulties encountered.
Freelancer's review of cooperation with Aleksey Smirnov
Setting up formulas in ExcelThank you for your cooperation! Everything is fine!
-
1 day11 USD
1 day11 USD
Good afternoon, I will do it as needed. I will propose the optimal solution. Feel free to reach out.
-
Winning proposal1 day22 USD
3012 73 4 2 Winning proposal1 day22 USD
Good day! I have extensive experience working with formulas in ET, so I can complete the assigned task quickly, and most importantly, with quality! Feel free to reach out!
-
5 days44 USD
190 5 days44 USD
I once created in Visual Basic in Excel an accounting system for tracking technical resources for a locomotive repair plant.
Feel free to reach out.
-
3 days18 USD
1308 44 5 1 3 days18 USD
Good afternoon. I am ready to implement it using a macro. Please write in private messages.
-
2 days22 USD
561 15 0 2 days22 USD
Good day! I will gladly help you with your task: if the priority is to remove duplicates, then for points 1,2 Excel has a great built-in function, highlighting with color is also not a problem. Points 3,4 can be done using formulas, but here, it seems to me, a script would be better, as it is more convenient for the user of the table. Write to me, we will discuss which options will be more convenient for you.
-
1 day11 USD
421 13 0 1 day11 USD
Hello!
I work with Excel and Google Sheets.
I am ready to help using formulas or macros (scripts).
Connection with Telegram bot and e-mail with Google Sheets.
I will be happy to collaborate.
Hello.
I work with Excel and Google Sheets.
I am ready to help using formulas or macros (scripts).
… Connection with Telegram bot and e-mail with Google Sheets.
I will be happy to collaborate.
-
2 days33 USD
1838 43 0 2 days33 USD
Good day!
Here, a macro needs to be written.
I have completed a similar project
https://freelancehunt.com/project/formuvannya-tablitsi-excel-zadanimi-parametrami/1396672.html
Feel free to reach out!
-
2 days33 USD
1380 76 6 3 2 days33 USD
I can implement a script through VBS that will be integrated with a macro in Excel; if needed, I can also implement it for Google Sheets using Apps Script.
-
1 day13 USD
2162 85 0 1 day13 USD
Ready to do it.
_____________________________________________
-
1 day13 USD
410 12 0 1 day13 USD
Good day! I am ready to complete your task. All details in private messages.
-
2 days13 USD
5911 345 0 2 days13 USD
I will closely examine the tables, and then it will be clear what to do: maybe the formulas will be enough, or maybe it will be necessary to write the corresponding macros. The price is currently uncertain, as the scope of work is not fully understood.
Current freelance projects in the category Databases & SQL
Accounting, planning, and sales system for a mushroom farm
600 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 ∙ 1 day 8 hours back ∙ 51 proposals |
External report 1C 8.3 — forecast of goods balances
22 USD
An external report (.erf) is needed for 1C:Enterprise 8.3 (configuration to be specified). What it should do: Extract product balances from the database Analyze sales history for the last 30 days Calculate the average sales rate for each product Determine how many days until the… Databases & SQL, Client Management & CRM ∙ 1 day 9 hours back ∙ 11 proposals |
Web Application & Database Security Audit for Custom CRM — BaaS / Database-as-API Specialist (Penetr
Project Overview We operate a custom-built customer relationship management (CRM) platform that runs two service businesses on a single system. It is a modern JavaScript web application backed by a backend-as-a-service (BaaS) database and deployed on a serverless hosting… Databases & SQL, Testing & QA ∙ 1 day 21 hours back ∙ 9 proposals |
Database synchronization
Synchronization of Microsoft Access programs and CRM SalesDrive. Data transfer from CRM to Microsoft Access in the first stage (changing the funnel status). Data transfer from Microsoft Access to CRM in the second stage (changing the status in the program). Databases & SQL ∙ 2 days 3 hours back ∙ 11 proposals |
Setting up a backup system and optimizing server infrastructure
Objective of the work: Ensure reliable data storage for the CRM system and application by implementing an automated backup system, as well as carry out a series of server improvements to enhance the stability, security, and performance of the infrastructure. DevOps, Databases & SQL ∙ 3 days 1 hour back ∙ 24 proposals |
Odessa