Featured Formulas

Lookup

Rank and score with INDEX and MATCH

In this example, the goal is to assign points based on a ranked score. The scores to rank are in column C, and the calculated Rank is in column D. Points are awarded based on the table in G5:H10. Both tblData (B5:E15) and tblPoints (G5:H10) are...Read more

More Formulas

Featured Videos

More Videos

Featured Functions

Text

TEXTJOIN Function

The TEXTJOIN function concatenates multiple values together with or without a delimiter. TEXTJOIN can concatenate values provided as cell references,  ranges, or constants, and can optionally ignore empty cells.

The TEXTJOIN function...Read more

More Functions

Recent Articles

More Articles

Topics By Category

Formulas

Shortcuts

Functions

User Testimonials

In the realm of Excel, I feel it is important to understand how & why specific formulas and functions work in particular situations, as well as how to build them. Never have I seen an organization systematically break down Excel’s built-in functions and comprehensively explain how each component ticks. You guys are incredible!
William
Your site is undoubtedly the best I have ever come across for learning excel. Lucid and clear. Amazing job done by you guys!
Jerry
Your e-mail updates are very helpful and I learn something with each one. Great job and keep them coming!
Karen
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