Macro for automatic grouping of lines in a Google table
11 USD How to look - https://prnt.sc/26swo2r
Let’s start with line 2. The logic of grouping:
Group levels.What groups columns.The logic of groupproof1st levelStolbets "G" Take data from the column "E", start with the first phrase and to the next, then again2nd levelStolbets "E" Take data from the column "C", start with the first phrase and to the next, then again3nd levelStolbets "A" Take data from the column "A", start with the first phrase and to the next, then again
In the innet found a similar macro, it may fit - https://www.planetaexcel.ru/techniques/9/47/
If there is uncomprehensible logic of grouping, we can call on Skype, I’ll show everything.
Client's review of cooperation with Oleksandr T.
Macro for automatic grouping of lines in a Google tableThe executive offered a lot of options, how to do, it was even better than I thought:) Cruel!
Freelancer's review of cooperation with Magic Traffic
Macro for automatic grouping of lines in a Google tableOrdered customer, the collaboration was pleasant and always happy to help again.
-
Winning proposal1 day11 USD
80 4 1 Winning proposal1 day11 USD
I can do this tonight. You can give a table, and I will make an example of grouping on its copy to make sure I’ve properly understood your logic.
-
1 day7 USD
1134 38 0 1 day7 USD
Good evening . I can write a macro in Excel. If your data looks like the picture, it’s more than understandable.
-
1 day9 USD
1115 109 0 1 day9 USD
Hello to you.
I can write a script for Google tables or macros for Excel file.
I do in the evening.
Write to LS, you need to look at the original data.
-
1 day10 USD
3668 107 0 1 day10 USD
Do you already have the data table?
Can you show?
I want to see the data structure.
-
Вам нужна гугл-таблица или ексель? На скрине - гугл-таблица, код - для ексель.
-
Magic Traffic Magic Traffic
Можно в гугл таблицы и в ексел.
-
по какому принципу должен идти отбор и группировка данных?
можете показать саму таблицу?
-
Current freelance projects in the category Databases & SQL
It is necessary to check the scripts and update the data in the Postgres database.It is necessary to correct the SQL scripts for the Postgres database. It is required to check the scripts and update data from external Excel tables and between two Postgres databases (different servers). Scripts will be run through AnyDesk using Navicat. List of data for… Databases & SQL ∙ 17 hours 5 minutes back ∙ 18 proposals |
Need an Airtable architect to build a relational schema and a new clean Airtable base.Need help rethinking and building a clean relational schema for an internal operational system on Airtable. The current database is already in use by the team, but it has grown organically: the structure is partially flat, some tables/views are actively used, while others are… Databases & SQL, Desktop Apps ∙ 1 day 10 hours back ∙ 9 proposals |
Basketball Coaching Education Platform + Custom CMSBasketball Coaching Education Platform + Custom CMSProject Overview We are looking for an experienced web development team or full-stack developer to build a modern basketball coaching education platform. The website will provide basketball coaches with access to educational… Databases & SQL, Web Programming ∙ 2 days 3 hours back ∙ 86 proposals |
Integration of Viber in 8.3
223 USD
Need Viber integration into own CRM (1C 8.3)About the Company The company "Domofon System" is engaged in the installation and maintenance of intercom systems. Base of over 40,000 subscribers. We work on our own customized system based on 1C 8.3. We are looking for a specialist… Databases & SQL, Bot Development ∙ 2 days 7 hours back ∙ 16 proposals |
Refinement of 1C UT 11 for Zebra TSD (RDP): different sound signals when scanning
22 USD
Configuration: 1C UT 11 Address warehouse Zebra TC26 TSD Work via RDP Product scanning is performed in receiving, placement, picking documents, and other warehouse operations. Current problem: Warehouse workers operate through the Zebra TSD. When scanning, they do not always… C#, Databases & SQL ∙ 4 days 5 hours back ∙ 6 proposals |
Kyiv