Create a document with formulas in Excel or Google Tables
There is a second large amount of data (D)
It is necessary to distinguish all the values that are simultaneously in columns A and D.
In the columns F, G and H, it is necessary to extract the names of categories and separately to each number of colored cells and the number of uncolored cells (recurring values and unique) from the column A.
I am applying example.
I need such a formula file so that I simply enter new values (>10000) in columns A, B and D, and immediately get the required values in F, G and H.
It is desirable to be done soon today.
Applications 1
Client's review of cooperation with Ilya Kulpin
Create a document with formulas in Excel or Google TablesEverything is done quickly and of high quality! I recommend cooperation
![]()
Freelancer's review of cooperation with client
Create a document with formulas in Excel or Google TablesA great customer. The task is clearly set. If you need clarification, always in contact.
-
Hello to you. Ready to perform in the best way. Go to turn. Experience in such tasks is great.
A systematic approach focused on your P&L and Cash Flow. I'd be glad to dive into your project details in private messages! -
812 15 0 Good day . I can do it without macros, it will quickly count, contact.
-
746 29 1 Good day ! I do it in Excel. It can be written in formulas. There is experience of creating such “learners”.
-
2073 116 0 Good day ! I can write the program - you upload your file to it, and as a result you get the necessary calculations and color allocation. Please call me, I'll be glad to help!
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 19 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 50 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 25 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 |