Scribd
Upload
14 views3 pages

Filter Function - Excel

Learn excel

Uploaded by

Anil verma
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
14 views3 pages

Filter Function - Excel

Learn excel

Uploaded by

Anil verma
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd

FILTER

FUNCTION
FILTER FUNCTION
 The FILTER function in Excel extracts
data based on a condition (or set of
conditions) you specify.

 =FILTER(array, include, [if_empty])

 array: The range of data you want


to filter.
 include: The condition(s) used to
filter the data.
 [if_empty]: (Optional) The value to
return if no data meets the condition.
FILTER: LOGICAL OPERATORS

You might also like