Featured Formulas

Count rows that contain specific values

In this example, the goal is to count the number of rows in the data that contain the value in cell G4, which is 19. The main challenge in this problem is that the value might appear in any column, and might appear more than once in the same row. If we wanted to simply count the total...Read more

Featured Functions

TEXTAFTER Function

The Excel TEXTAFTER function extracts text that occurs after a given delimiter. When multiple delimiters appear in the text, TEXTAFTER can return text that occurs after the nth instance of the delimiter. TEXTAFTER can also extract text after a specific delimiter when counting...Read more

Recent Articles

YOU ARE COMPLETELY BRILLIANT. I find myself coming back to your site by default, again and again. I've now bookmarked it and shall shortly write an IFERROR macro to bring me here automatically!
Ian
Thank you so much for taking the time to send these notes and very useful shortcuts in Excel. They are extremely helpful and I really enjoy the format you use.
Virginia
I had an urgent requirement to clean some excel data. Went through your website. Excellent explanation and great help.
Haroon

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