Vision Data Fiber

Vision Data Fiber Automate your business process with Vision.

Production Dashboard be like🥰🥰
14/03/2024

Production Dashboard be like🥰🥰

Here is a script to create a pdf file of Google sheet and send email automatically
14/02/2024

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() ...
07/02/2024

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 ...
06/02/2024

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...
01/02/2024

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 ...
31/01/2024

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 regardi...
26/01/2024

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
25/01/2024

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, Purcha...
20/01/2024

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 y...
12/12/2023

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.

Address

Kashipur
244713

Opening Hours

Monday 10am - 7pm
Tuesday 10am - 7pm
Wednesday 10am - 7pm
Thursday 10am - 7pm
Friday 10am - 7pm
Saturday 10am - 7pm

Telephone

+919119715078

Alerts

Be the first to know and let us send you an email when Vision Data Fiber posts news and promotions. Your email address will not be used for any other purpose, and you can unsubscribe at any time.

Contact The Business

Send a message to Vision Data Fiber:

Share