Google Table (Excel) Help
It is the following:
It is necessary that from the Three tables the information is automatically transferred to one.
Additionally, you need to set the following formula =HOTESLIMN('2022.01.17'!I:I; A5; '2022.01.17'!H:H; "In Work")+HOTESLIMN('2022.01.17'!I:I; A5; '2022.01.17'!H:H; "Rights")+HOTESLIMN('2022.01.17'!I:I; A5; '2022.01.17'!H:H; "Plan")+HOTESLIMN('2022.01.17'!I:I:I; A5; '2022.01.17'!H:H:H; "Plan")+HOTESLIMN('2022.01.17'!I:I:I:I:I:I:I:I:I:I:I:I:I:I:I:I:I:I:I:I:I:I:I:I:I:I:I:I:I:I:I:I:I
adding the condition that it counts only when the month is "flower".
The request of people without experience and to "prove" is possible to come out - not touch.
For example, you need a formule of Query.
by P.S. - if there is a possibility to make the tables synchronized in BETWORK PAGE - it would be great
Client's review of cooperation with freelancer
Google Table (Excel) HelpIt’s all just wonderful!
I recommend it! Saving a lot of money
Freelancer's review of cooperation with Oleksandr Kanyuk
Google Table (Excel) HelpEverything is great. I was pleased to cooperate.
![]()
-
3621 113 7 1 Good day
I have a decision to your task.
Write in person for discussion
-
1134 38 0 Good day . I can do. Excel at a high level.
-
1677 43 0 Good day !
Alexander, send the links to the tables, I will set it tomorrow until 11 a.m., I will also review that you may have some suggestions for optimization with the data.
-
Добрый день!
Ещё хотел один момент уточнить, а вывод информации через Data Studio - преобразование в интерактивные Дашборды Вы не рассматриваете?
По решению, да квери необходимо использовать и тянуть сразу с трёх источников, чтобы группировалось корректно, так как если использовать только Importrange начнутся танцы с бубном - а мы этого не хотим)
и жду ответ по Google Data -
Якщо Ви про те що коли дані вносяться у таблиці вони одразу ж попадають до основної то звісно, якщо щось інше, прошу уточнити!)
-
Current freelance projects in the category Data Parsing
Data parsing through mobile APILooking for a person with experience in data parsing through mobile API, for parsing e-commerce, rozetka and similar sites. Tasks: 1. Intercepting traffic from the mobile application (Android), setting up a proxy, analyzing requests. 2. Identifying the necessary API endpoints… Python, Data Parsing ∙ 23 hours 40 minutes back ∙ 23 proposals |
Looking for a programmer or vibe coding Automation scraping data 2https://drive.google.com/file/d/14tP5XWJB9acV4gn_cJrFwMpihUj3EbQz/view?usp=sharing I accidentally sent that link Web Programming, Data Parsing ∙ 1 day 2 hours back ∙ 31 proposals |
Create a dashboard in https://airtable.com/ for the performance of advertising creatives from Facebook ads.Full specification https://docs.google.com/document/d/1_n_oYRNZWYxalUA---DM5AD1b5ZSrtePw5J4G42svGw/edit?usp=sharing Databases & SQL, Data Parsing ∙ 5 days 20 hours back ∙ 19 proposals |
Creation of an Excel file for uploading products to the websites of other partners.I am interested in creating an Excel table with all parameters. Here is the website - https://heiztechnik.com.ua/ And the positions I am interested in to be transferred: Manual boilers: 1) TIS UNI 15-95 kW (10) pcs 2)TIS HARD 150-500 kW (7) pcs Pellet boilers: 1)TIS PELLET… Data Parsing ∙ 6 days back ∙ 37 proposals |
A developer is required for parsing the catalog and automating data import.Detailed technical specifications in the attached document Please indicate the estimated cost and timeline in your response Do you have experience working with parsing large catalogs What possible difficulties or limitations do you see in this task Databases & SQL, Data Parsing ∙ 6 days 3 hours back ∙ 42 proposals |