By sc
In excel filter formula is used to filter a range or an array based on some criteria.we can also filter out any content as we do using normal filter.
How to use Filter formula in Excel:
- As shown in above image we have filter No. column based on country by using filter formula.first we have to select array which we have to output as result then the another array on which condition basis we want to filter out.In above example we have filter out based on condition “India”.
- We can also combine filter formula in excel with Transpose formula to display result in row as shown in image where we have filter based on condition “United States”.