Vision Data Fiber

Production Dashboard be like🥰🥰

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 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.