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

More Functions

Recent Articles

More Articles

Topics By Category

Formulas

Shortcuts

Functions

User Testimonials

You have saved me HOURS of work. Thank you so much!!!!
Jennifer
When querying functions, I often end up on your site. And, the explanations are always clean and comprehensive. So, I appreciate the work you're putting into this.
Chris
Just wanted to say thank you for the formulas. I find the formulas easy to understand (explained so clearly) and have used the website so many times. It has become my go to place for any clarification. This is a great initiative on your part. Keep up the good work.
Mark
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