Featured Formulas

Dynamic array

Extract common values from text strings

In this example, the goal is to extract common values from two text strings that contain comma-delimited values. In the worksheet shown the values for "List1" appear in column B and the values for "List2" appear in column C. The results in column D show the intersection of the two lists, that is...Read more

More Formulas

Featured Videos

More Videos

Featured Functions

Dynamic array

TRIMRANGE Function

The TRIMRANGE function removes empty rows and columns from the outer edges of a range of data. Given a range or array, it will exclude empty rows and/or columns and return a "trimmed" range that contains only data. The beauty of TRIMRANGE is that it will track the data in a worksheet as it...Read more

More Functions

Recent Articles

More Articles

Topics By Category

Formulas

Shortcuts

Functions

User Testimonials

I have used vlookup a lot and read some about index and match, but decided to add extra columns and stay with vlookup, however, your site was so very clear that making the switch (only where necessary) was very easy. For the first time, I understand index and match match. Thank you.
Garth
Hi, your website is far easier to understand and use than any other I've seen. I find myself always typing in my questions on google with "exceljet" in the search bar because yours is so clear and versatile in it's application.
Jennifer
The best site I ever found on any programming/software topic on the Internet. Period! I can not find words to express my admiration for the clarity, precision and insight with which you put your site together. Thank you.
Mario
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