FILTER Function
=FILTER(array, include, [if_empty])| Argument | Description |
|---|---|
array(required) | The range of cells you want to filter. |
include(required) | A logical expression that determines which data to include. |
[if_empty](optional) | A value to return if no data matches the criteria. |
Share on
ExcelGuy is your trusted source for practical MS Excel tutorials, tips, functions, formulas, and shortcuts. I’m your everyday guide to help you boost productivity and master Excel’s functions.
By entering your email, you agree to our
Terms & Conditions and Privacy Policy.
© ExcelGuy. All rights reserved
Popular Functions
Excel Shortcuts
Text Functions
Excel Guy is your trusted source for practical MS Excel tutorials, tips, functions, formulas, and shortcuts. I’m your everyday guide to help you boost productivity and master Excel’s functions.
By entering your email, you agree to our Terms & Conditions and Privacy Policy.
© ExcelGuy. All rights reserved
Popular Functions
Excel Shortcuts
Text Functions
Excel Guy is your trusted source for practical MS Excel tutorials, tips, functions, formulas, and shortcuts. I’m your everyday guide to help you boost productivity and master Excel’s functions.
By entering your email, you agree to our
Terms & Conditions and Privacy Policy.
Popular Functions
Excel Shortcuts
Text Functions
© ExcelGuy. All rights reserved