Featured Formulas

Split text string at specific character

In this example, the goal is to split a text string at the underscore("_") character with a formula. Notice the location of the underscore is different in each row. This means the formula needs to locate the position of the underscore character first before any...Read more

Featured Functions

XLOOKUP Function

XLOOKUP is a modern replacement for the VLOOKUP function. It is a flexible and versatile function that can be used in a wide variety of situations.

XLOOKUP can find values in vertical or horizontal ranges, can perform approximate and exact matches, and supports wildcards (* ?) for...Read more

Recent Articles

Why SUMPRODUCT?

In this article, I attempt to explain why you see SUMPRODUCT so often in formulas, and when you can use the SUM function instead. The short version: SUMPRODUCT supports array operations natively, which makes it very useful for solving seemingly unrelated...Read more

Just a short note to thank you for all of the free info you’ve put out there. Once again, I was stuck on something and just looked it up in your library of lessons. I was able to figure out the problem immediately.
Jeff
I think I love you. This is going to save me hundreds of hours a year.
Cantaro
Thank you very much. The function is working fantastically. It saved me at least 3 full working days.
Rajesh Ramachandran

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