(Copy/Paste the formula above into your sheet and modify as needed) Click here to read the Excel version of this article Using the FILTER function in Google Sheets is almost the same as using it in Excel, but there are slight differences between the two.
=FILTER('Sheet Name'!A3:B,'Sheet Name'!B3:B="Full Time").=FILTER(A3:C,C3:CHere are the Google Sheets Filters formulas: Filter by a number This article focuses specifically on the FILTER function that is typed into the spreadsheet cells as a formula, and not the filter command available from the toolbar and pop-up menus. In this article I will start with the basics of using the FILTER function (examples included), and then also show you some more involved ways of using the FILTER function. Your entire formula will look like this: =FILTER(A1:B,B1:B>3) Type a closing parenthesis and then press enter on the keyboard.Type a comma, and then type the condition for the filter, such as B1:B>3 (To set a condition, first type the address of the "criteria column" such as B1:B, then type an operator such as greater than (>), and then type the criteria, such as the number 3.Type the address for the range of cells that contains the data that you want to filter, such as A1:B.