Featured Formulas

Dynamic array

Extract common values from two lists

In this example, the goal is to compare the values in two different lists, then extract the values that appear in both lists into a third list as shown in the worksheet above. The values for List 1 appear in column B, and the values for List 2 appear in column D. Although we have a list of...Read more

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

Your website is the best. I really appreciate all of the concise descriptions, it has helped me in countless ways over the last few years as an analyst. Invaluable information.
John
You certainly provide the clearest explanations of how to use Excel that I have ever seen! Thanks very much for sharing!
Mike
This is an Excel Knowledge Gateway made simple, where every step of a formula is included and well-explained in a proper order.
Emmanuel
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