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
RANDARRAY Function
The Excel RANDARRAY function generates an array of random numbers between two values. The size of the array is specified by rows and columns arguments. The generated values can be either decimals or whole numbers.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
I love the repertoire of videos and tips you guys have put together over the years, it has been a fantastic help to my career. The other thing that makes you guys stand apart is that the access doesn’t expire!
Paul
Do You Have a T-Shirt? I Love ExcelJet Desperately. Seriously, you guys have saved my butt a BILLION TIMES. I've copied a bunch of your formulas into my software consulting training materials. I often find myself up at 2 AM with a daunting project in front of me, only for one of your formulas to cut my project time by 90%.
Peter
Just wanted to say you are my go to website for any excel question for good few years and taught me a lot. No other resource can explain the steps better than you do. You made such a difference. It is amazing.
Al
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.
