FILTER with optional criteria
To filter data with multiple criteria that are all optional, you can use the FILTER function with the LET function. In the example shown, the formula in B5 is: …Read more
Learn Excel with clear examples and bite-sized videos.
Featured Functions
FILTER Function
The Excel FILTER function is used to extract matching values from data based on one or more conditions. The output from FILTER is dynamic. If source data or criteria change, FILTER will return a new set of results. This makes FILTER a flexible way to isolate and inspect data without altering the …Read more
Recent Articles
Combinations and permutations in Excel
Combinations and permutations are two basic ways to count possibilities, used in probability, statistics, games, passwords, and lotteries. This article explains the difference between them, when order and repetition matter, and the Excel functions you can use to calculate each case: FACT, PERMUT, …Read more
Topics By Category
User Testimonials
Keep up the good work - you're my go to site for Excel queries and I'm very grateful for all of the knowledge that you share!
Jon
I work in IT support for a big law firm. Since I started with your lessons, the amount of Excel requests in my daily work increased tremendously. I get so much positive feedback and my colleague asked me the other day not to go on vacation simultaneously with the head of the Excel-Team again.... Thank you very much for your excellent work!
Carolin
Thanks for you website. I've learned a lot from a variety of resources but yours is a favorite. I've made some great strides while I'm rewriting a spreadsheet that has portions that goes back 20+ years, mostly in the use of arrays in OFFICE 365.
Gregory
Get Training
We offer free resources and paid training.
Learn Excel with high quality video training. Our videos are quick, clean, and to the point, so you can learn Excel in less time, and easily review key topics when needed.
