Excel Filter Function Techniques

Overview

• Filter function in Excel: Powerful and versatile for data manipulation.
• Promise: By the end of the video, you'll become adept at using the filter function.

Basic Structure of the Filter Function

• Arguments: 3 total; 2nd argument most important.
• Example:
  • Formula: =FILTER(data, condition, if_empty)
  • Conditionally checks for true/false and returns the corresponding values.
  • If no values match, it shows a custom message or placeholder.

Using Multiple Conditions

AND Condition

• Formula: =FILTER(data, (condition1) * (condition2), if_empty)
• Example when 'Type' is Commercial and 'Annual Rent' > 5000.

OR Condition

• Formula: =FILTER(data, (condition1) + (condition2), if_empty)
• Example when 'Type' is Commercial OR 'Annual Rent' > 5000.

Error Handling

• Final Argument Handles Errors: 
  • Example: Shows