Featured Formulas

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

Featured Functions

SUMIFS Function

The SUMIFS function sums numbers in Excel when they meet one or more specific conditions. SUMIFS is one of Excel's most widely used functions, and you will see it in all kinds of spreadsheets that calculate conditional sums based on dates, text, or numbers. Although a common function, ...Read more

Recent Articles

Hello I receive your newsletter and it is always helpful. I improved productivity 100 times over with you helpful tips.
SP
I found Exceljet through a google search when I was trying to figure out the correct syntax for a formula. Of course, when you do a search in this manner, several options pop up. Well, after looking at several websites that allegedly had the answer to my question, I finally took a gander at your site. BINGO!! Exceljet had the answer because you provide very detailed explanations AND examples. My problem solved. After that experience, I always turn to Exceljet first. So far, I have not had to look any further.
Barbara
Just a brief view of your website, and one specific idea - a "helper" value column - allowed me to do in less than two hours something I had been going down dead-ends with for two days. Thank you, thank you, thank you!
Roberta

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