Vision Data Fiber

Production Dashboard be like🥰🥰

Here is a script to create a pdf file of Google sheet and send email automatically

How to sum values row by row across the google sheet via applying function at a time?

We can do this by applying BYROW() with LAMBDA function. Here, I have a small data and need to sum all values row by row. I applied BYROW() with LAMBDA and MAX(),MIN() and SUM(). It is giving result row by row. First I entered the range, and applied the function.

Syntax: BYROW(array_ or_ range, lambda)
Here, I took three examples of LAMBDA() function with SUM(), MIN() and MAX().

Syntax: LAMBDA ([name, …], formula_ expression)

Here, I have shared some examples of Vlookup and Vlookup with Match function which are very useful while we are working on a big database and need to extract some information based on a key. If we used row function or column function and Match with Vlookup we don't need to apply formulas again and again. It will give result automatically.

If you want to send automatically replies to your customer query via email, here is script that will connect your Google sheet and email.
You can also contact us for automation templates. We will customise it as per your requirement

If we are stuck in getting sum of all values based on particular date in Google sheet and somehow SUMIFS is not working then what should we do?
Please apply the Query formula as it is explained in the given image.

Lead Analysis Templates which maintains your leads and analysis data weekly and you can also use all information regarding a particular lead with a single click

May the pride of being Indian fill your heart with joy and gratitude. Happy Republic Day to you and your family

Join us to get solution of all problems related to manage database. We provide services in Production Management, Purchase Management
Sale Management and Financial Management.
Visit us on www.datafiberblog.wordpress.com
# Excel
# Google Sheet

If you have a big data and has to find only unique values how can you do it in Google Sheet?
If you have a big data and you are firmly believe that some entries repeated and want to take only unique values, we will use UNIQUE() function. It takes only unique values which values is unique in every column.
Syntax: UNIQUE(range, by_column, exactly_once)
Let's see with an example.
Here, I have a small data in which Employee ID A1001 is repeated with all values in every column, UNIQUE did not take it.
In second example, I have changed Department Name so UNIQUE took this ID since it has different values in a column.