How to Use the FILTER Function in Google Sheets | What is the unique function in Google Sheets
Online live Course Link:
https://sites.google.com/view/tanvira...
In Google Sheets, the FILTER function is used to filter data based on specified criteria. It allows you to extract only the data that meets certain conditions. The basic syntax of the FILTER function is as follows:
excel
Copy code
=FILTER(range, condition1, [condition2, ...])
range: The data range that you want to filter.
condition1, [condition2, ...]: One or more conditions that determine which rows to include in the filtered result.
Here's a simple example:
Suppose you have data in columns A and B, and you want to filter the rows where the values in column B are greater than 10. You would use the FILTER function like this:
excel
=FILTER(A:B, B:B greater than 10)
This formula filters the data in columns A and B, including only the rows where the corresponding value in column B is greater than 10.
Now, regarding the "unique function" in Google Sheets, there isn't a specific function called "UNIQUE" in the context of filtering data. However, you can achieve a similar result using the UNIQUE function in combination with FILTER to filter unique values.
Here's an example:
Suppose you have a list of names in column A, and you want to create a list of unique names. You can use the following formula:
excel
=UNIQUE(A:A)
This formula will give you a column of unique values from column A.
If you want to filter unique values based on a condition, you can combine UNIQUE and FILTER:
excel
Copy code
=UNIQUE(FILTER(A:A, B:B greater than 10))
This formula first filters the data based on the condition (B:B greater than 10) and then extracts unique values from the filtered result.
Keep in mind that the exact formulas you use will depend on your specific data and filtering requirements.
#googlesheetstutorial
#msexcelfullcourse
#msexcel
COMMUNICATE WITH HASAN ACADEMY
[email protected]
Facebook page
/ hasanacademybanglatutorial
Subscribe link : / @hasanacademy779
Facebook group link : / 282270382269650