Featured Formulas

Lookup

XLOOKUP with regex match

In this example, the goal is to look up the correct price of the product number entered in cell F4 using the product codes in column B. This problem is trickier than it looks. Each product code begins with 3 uppercase letters and ends with 2 or 3 uppercase letters. In the middle of the...Read more

More Formulas

Featured Videos

More Videos

Featured Functions

Date and time

DATEDIF Function

The DATEDIF function is designed to calculate the difference between two date values in years, months, or days. The result from DATEDIF is a number that corresponds to the time unit requested. DATEDIF is a versatile function that can be used in financial analysis, project planning, age...Read more

More Functions

Recent Articles

More Articles

Topics By Category

Formulas

Shortcuts

Functions

User Testimonials

Just found your web page above to be able to copy the formula down the new columns without having to change any of the formula. This is so cool, has been a real GODSEND - I'm so grateful for you making this available.
Ian
Your site is the best Excel resource, period. I first discovered you when I googled pivot tables and read "Can Pivot Tables Save Your Job". That article is so true! I've since developed expertise in regular Tables and made a workflow management tool for my job, which in turn has made me the only person in a collaborative of hospitals to be complete and on-time with data delivery. Because of this, I have proven value and credibility, and owe it all to developing my skills with your site.
Fred
Your website is a Godsend! I am trying to help a small business update their 60+ manufacturer prices from formatted excel spreadsheets into Quickbooks and it has been a significant challenge. I am making progress but only with the help of your website.
Vicki
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