Buzz
I'm currently working with Google Sheets to create a summary table of data taken from another sheet. Using the Filter function in Google Sheets is perfect for my needs, especially since Excel doesn't have this function. With the Filter function, you can input a formula into the first cell of your data table, and Google Sheets will fill in all the cells below if they match your conditions. Below are detailed instructions on using the Filter function.
USING FILTERS IN GOOGLE SHEETS
Illustration: I have a table with names, genders, ages, and locations on Sheet 1. Now I want to filter out people aged over 20, and the information will be filled into a table on Sheet 2.
The formula for the Filter function is as follows: =filter(range, condition 1, [condition 2]…)
Where:
- range: are the cells containing the source data we want to retrieve.
- condition 1, condition 2: are specific conditions
So the formula for the spreadsheet I'll enter is =filter(Sheet1! B7:B11,Sheet1!C7:C11>20)
In my formula, Sheet1! B7:B11 represents the data cells I want to retrieve and fill into the table on Sheet 2. Sheet1!C7:C11>20 is my retrieval condition.
That's it! Google Sheets will automatically fetch results from Sheet 1 and fill in all the names meeting the condition of being Over 20 years old.
You can absolutely use this formula to retrieve even more information by simply changing the 'range '.
Above is a detailed guide on how to use filters in Google Sheets. Mytour hopes this article will make your work easier. If you encounter any difficulties during use, feel free to comment, and Mytour's technical team will assist you.
Furthermore, Google Sheets also supports users in filtering data by color. If interested, you can learn more about filtering data by color on Google Sheets here.
