Excel FILTER Function read tutorial watch tutorial
Syntax: =FILTER(array, include, [if_empty])
array is the range or array containing the values you want filtered.
include is the logical test that returns a Boolean array (TRUE/FALSE) the same height or width as the array.
if_empty is an optional value to return if the included array are empty i.e. if the filter results in no records.
Department Item Quantity Price Total $
Support Stamps 50 0.60 30.00
Support Paper 10 4.99 49.90
Support Pens 15 0.95 14.25
Front Office Stamps 250 0.60 150.00
Front Office Paper 30 4.99 149.70
Front Office Pens 50 0.95 47.50
Sales Stamps 200 0.60 120.00
Sales Paper 20 4.99 99.80
Sales Pens 25 0.95 23.75
Filtered Data{=_xlfn._xlws.filter(B11:F19,B11:B19="Sales","No Records")}
Department Item Quantity Price Total $
#NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME?
Filtered Data Using AND Criteria (*)
Department Item Quantity Price Total $
#NAME? #NAME? #NAME? #NAME? #NAME?
Filtered Data Using OR Criteria (+)
Department Item Quantity Price Total $
#NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME?
Filtered Data with Multiple if_empty Criteria
Department Item Quantity Price Total $
#NAME? #NAME? #NAME? #NAME? #NAME?
Exctract Non-contiguous Columns
Department: Front Office
Item Price Quantity
#NAME? #NAME? #NAME?
#NAME? #NAME? #NAME?
#NAME? #NAME? #NAME?
watch tutorial
eight or width as the array.
filter results in no records.
Data Validation List
#NAME?
#NAME?
#NAME?
More Resources
Tutorials
Excel Functions..............................................................
Charting Blog Posts.....................................................
Excel Dashboard Blog Posts.....................................
Webinars
Excel Dashboards & Power BI..................................
Courses
Advanced Excel..............................................................
PivotTables......................................................................
Power Query...................................................................
Power Pivot.....................................................................
Excel Dashboards..........................................................
Power BI...........................................................................
Excel for Decision Making Under Uncertainty...
Excel for Finance Professionals................................
Excel Analysis ToolPak................................................
Excel for Customer Service Professionals............
Support
Excel Forum.....................................................................
https://www.myonlinetraininghub.com/excel-functions
http://www.myonlinetraininghub.com/category/excel-charts
http://www.myonlinetraininghub.com/category/excel-dashboard
http://www.myonlinetraininghub.com/excel-webinars
https://www.myonlinetraininghub.com/excel-expert-upgrade
https://www.myonlinetraininghub.com/excel-pivottable-course
https://www.myonlinetraininghub.com/excel-power-query-course
https://www.myonlinetraininghub.com/power-pivot-course
http://www.myonlinetraininghub.com/excel-dashboard-course
http://www.myonlinetraininghub.com/power-bi-course
https://www.myonlinetraininghub.com/excel-for-decision-making-course
https://www.myonlinetraininghub.com/excel-for-finance-course
https://www.myonlinetraininghub.com/excel-analysis-toolpak-course
https://www.myonlinetraininghub.com/excel-for-customer-service-professionals
https://www.myonlinetraininghub.com/excel-forum
