Filter Function in excel dynamic arrays multiple criteria | Filter Function Examples | learn xtra
Hello Everyone,
Welcome to Learn Xtra 😍
What is Filter Function in Excel?
How to use Filter Function in Excel?
FILTER FUNCTION
The Excel FILTER function "filters" a range of data based on supplied criteria.
FILTER function allows you to easily extract matching records from a larger set of source data based on criteria you provide.
The results from FILTER FUNCTION are dynamic.
When values in the source data change, or the source data array is resized, the results from FILTER will update automatically.
Dynamic Arrays - • What are the Excel Dynamic Arrays In Offic...
Count Function in Excel - • Excel Count, Counta, Countblank, Countif, ...
TIME STAMP:
0:00 Introduction
0:17 Filter Function
1:12 And Condition
4:15 Or Condition
5:16 Alternative Rows
7:48 Sort and Filter Function
9:48 Blank Cells
10:56 Unique values
FILTER FUNCTION USING AND CRITERIA
We can add multiple criteria to the INCLUDE argument by surrounding them in parentheses and using the multiplication operator OR Asterisk (*)
Only those records which matches all the criteria, is returned by the FILTER function as an answer.
FILTER FUNCTION USING OR CRITERIA
We can add multiple criteria to the INCLUDE argument by surrounding them in parentheses and using OR criteria by using the + operator.
Notes-
Filter can work with both vertical and horizontal arrays.
The include argument must have a dimension compatible with the array argument, otherwise filter will return #VALUE!
If the include array includes any errors, FILTER will return an error.
If FILTER is used between workbooks, both workbooks must be open, otherwise FILTER will return #REF!.
Watch the video till the end to learn everything in detail. If you have any doubts regarding this video or any other video, do let me know in the comment section.
Do LIKE 👍🏻 SHARE 🤞🏻 & SUBSCRIBE 👆🏻MY CHANNEL to get notifications of all latest videos ❤️❤️
Follow me at:
Facebook- https://bit.ly/2RLKYPN
Telegram- https://t.me/learnxtra
Other video you might like:
Pivot Table in Excel
• Excel Pivot Table | Pivot table for beginn...
Vlookup Function in Excel
• Different ways of using VLOOKUP Function i...
How to use match function in Excel?
• How to use Match Function in Ms Excel | Ma...
Send email from Excel (Part 2)
• Send email from excel using Hyperlink | Fu...
Send email from Excel (Part 1)
• Fully Dynamic Emails From Excel | Fully Au...
IF Function in Excel
• IF Function in Excel | IF & AND Function |...
MIS Report in Excel
• Astonish Everyone with MIS Report in Excel...
If you want YouTube Tips & Tricks, Do visit my channel
Live Proof 🔥New YouTubers must know | Don't do these mistakes | Complete 4000 hours 😱 : • Live Proof 🔥New YouTubers must know | Don'...
Hope you will like the video 🥰
Thankyou so much for watching 🙈
Queries solved in the video-
How to use filter Function in Excel?
How to add multiple criteria in Filter Function?
How to use AND CRITERIA in Filter Function?
How to use OR CRITERIA in Filter Function?
How to use Filter Function when cells are blank?
How to use Filter Function in blank cells?
How to use filter Function with count Function to get unique items?
How to use include argument in Filter Function?
How to use if empty argument in Filter Function?
#FilterFunction
#Filterfunctionwithmultiplecriteria
#learnxtra
#Andcriteriainfilterfunction
#orcriteriainfilterfunction
#filterfunctionexamples
#filterfunctioninexcel
#blankcells
#countfunctioninexcel
#uniquefunctioninexcel
#uniquefunction
#exceldynamicarrays
#dynamicarrayfunctions
COMPATIBILITY:
This file uses the new Dynamic Array Functions that are only available on the latest version of Office 365.
Nesta página do site você pode assistir ao vídeo on-line Filter Function in excel dynamic arrays multiple criteria | Filter Function Examples | learn xtra duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário Learn Xtra 20 Setembro 2020, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 925 vezes e gostou 5 espectadores. Boa visualização!
