Ditutup

Google sheet query

I use google sheet tables in which I fill in multiple "databases". I use data from databases to structure them with a google sheet and use them for reports. The existing formula I use to get my data out is: = if ($ B $ 1 = "Payment"; query (D! $ A $ 2: $ T; "select I, A, D, K, L where C = '" & $ A $ 1 & "'and B =' Output invoice 'order by'" & $ F $ 1 & "'"; 0); query (D! $ A $ 2: $ T; "select I, A, D, K, L where C = '"& $ A $ 1 &"' and (B = 'Construction site - situation / invoice' or B = 'Invoice' or B = 'Offer / proforma invoice') order by '"& $ F $ 1 &"' "; 0)).

it needs to be refined to automatically summarize projects by summing up an individual project and providing data according to a formula. An example is in the task file. Eg. it is necessary to summarize the "Daruvarske toplice" project and the "Lipik specijalna bolnica" project. Picture "tablica e" is current state, and picture "tablica e new" is future state. Formula must be in quary form as current.

Kemahiran: Excel, Pemprosesan Data, Pemasukan Data, Google Sheets, Excel Macros

Lihat lagi: custom reports in google analytics let you do which of the following?, combine tables from multiple sheets in the same workbook with power query, power query append multiple tables, power query merge multiple tables, google sheets query multiple sheets, google sheets query select multiple columns, google sheets query multiple criteria, google sheets query another sheet, mysql query examples multiple tables, custom reports in google analytics let you do which of the following, case studies on the safety management at construction site, google sheets query multiple sources, google sheet api query, update query with multiple tables, google sheets query multiple ranges, link google sheet to big query, which option gives us choice to open the tables forms and reports, which of the following google sheet formulas are related to the web?, google sheet formulas are related to the web, google sheets query((importrange multiple sheets))

Tentang Majikan:
( 0 ulasan ) Croatia

ID Projek: #30538184

17 pekerja bebas membida secara purata €28 untuk pekerjaan ini

(440 Ulasan)
8.3
(63 Ulasan)
6.3
IgeS

Hi there, You want to have the Query formula modified? You need a new group "New Project" and the sum of each groups added in the Query formula? Please message me if this is any of what you need. I'll be standing by Lagi

€40 EUR dalam sehari
(39 Ulasan)
5.3
AnuradhaVM

Hi, Greetings! ✅checked your project details. I can build google sheet query. I Have 4 years of experience with Data entry, Data analysis, and MIS Management. I have Power BI and Excel/google sheet skills and am able t Lagi

€30 EUR dalam 2 hari
(30 Ulasan)
4.5
Monirulop

Hi, I am ready to start right now. I can help you with your project according to your requirements. I am interested in your project. I ensure I will complete the task successfully and within the specified time. I love Lagi

€30 EUR dalam sehari
(23 Ulasan)
4.0
(28 Ulasan)
3.8
ArioNugroho

Hello, I can help you with this project. From what I understand you want the query to show summaries of multiple projects. I'm pretty sure I can do this job for you. I have created many google sheet files and excel fi Lagi

€30 EUR dalam 3 hari
(6 Ulasan)
3.1
irwantocirebon

I've been craving this for a long time, this job suits me perfectly, because I'm the best at writing and editing data professionally

€19 EUR dalam 7 hari
(0 Ulasan)
0.0
purohitdheeraj75

Hello I have 4 years of experience in this field IL do my work neat and clean and also my speed is very good so do select me for this work

€19 EUR dalam 7 hari
(0 Ulasan)
0.0
SPKarthik95

Hi, I have read your job description and will work as per your requirement within time.

€19 EUR dalam 7 hari
(0 Ulasan)
0.0
gurunathguru

I can complete your project as you need i.e. today because I have an experience of 3 years in this field and my main business is data entry.

€19 EUR dalam 7 hari
(0 Ulasan)
0.0
crnithinkumar

I'm a Data Analyst, Who can work on Excel with full knowledge and i'm a certified Microsoft Excel Expert which can help you in cutting down the project timing and i can help you with implementing easier technique to si Lagi

€22 EUR dalam 7 hari
(0 Ulasan)
0.0
vermaaakash311

Hi there, I am expert in Web search, Research, Market Research, Lead Generation, Web Scraping and Data Entry. Lets have a quick chat on this project to clear further details.

€25 EUR dalam 7 hari
(0 Ulasan)
0.0
gouravkashyap293

I will deliver your project in time and there will not be delay in my work. I assure that you will like my work. I am here for long term work relationship so will give 101% best output from my end so that you consider Lagi

€19 EUR dalam 7 hari
(0 Ulasan)
0.0
AwasthiVaibhav

Hello, I have fully understood your requirement and went into details of your input and required output file. I have several years of experience in working with excel and am a established programmer. I am new to freela Lagi

€10 EUR dalam sehari
(0 Ulasan)
0.0
digveshkmr1

I am expert in this work because I am doing this since 2016. so, please give a chance to doing this.

€19 EUR dalam 7 hari
(0 Ulasan)
0.0
lihansalk15

Hello dear client, Thanks for posting the job. I went through your job carefully and wish to inform you that I'm very much glad to accept this job which matches with my potential. Please find below my skills and stan Lagi

€12 EUR dalam sehari
(0 Ulasan)
0.0