Featured Formulas

More Formulas

Featured Videos

More Videos

Featured Functions

Dynamic array

FILTER Function

The FILTER function "filters" data based on one or more conditions, and extracts matching values. The conditions are provided as logical expressions that test the source data and return TRUE or FALSE. The result from FILTER is an array of matching values from...Read more

More Functions

Recent Articles

More Articles

Topics By Category

Formulas

Shortcuts

Functions

User Testimonials

This site rocks. Great work on maintaining it. it contains very valuable info in a synthesized way. I often refer colleagues to it when they struggle with an excel problem. Keep it up guys, and thank you for slowly turning me into an excel wiz.
Ivu
Just wanted to say thank you for your random name list formula. Your solution helped me condense several columns into 1 cell!!
Jarvis
You product is phenomenal! Easy to understand and gets to the meat of the function quickly.
Jennifer
More Testimonials

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.

View Paid Training & Bundles

Just show me the free stuff

Excel 101 and Core Pivot Packages