FILTER Function Explained
FILTER returns a filtered list of values from a range that meet a certain criteria.
It is part of the Excel Dynamic Array Formulas. This is a group of formulas which allows the user to type a formula in a single cell, and receive a result in a whole range.
It is important to note that as of December 2019, this function is available only for Office 365 and Excel Online Users. TheExcelBee.blogspot.com enables you to practice those formulas regardless of which desktop version you have! 🙂
Example
Syntax
=FILTER(array,include,[if_empty])
array – The range from which we want to extract the filtered values.
Example: A table with all the data B3:D9
include – A Boolean array i.e. – the range in which the filter criteria is applied AND the criteria itself.
Note: The Height/Width of the criteria has to be equal
Example: C3:C9=”Tech”
if empty – (Optional), the value to be returned from empty filtered results
Example: “Empty Cell”