Featured Formulas

Average top 3 scores

In this example, the goal is to calculate an average of the top 3 quiz scores for each name listed in column B. For reference, column H has a formula that calculates an average of all 4 scores. This is a slightly tricky problem, because it's not obvious how to limit the scores included in the...Read more

Featured Functions

UNIQUE Function

The Excel UNIQUE function extracts a list of unique values from a range or array. The result is a dynamic array of unique values. If this array is the final result (i.e. not handed off to another function), array values will "spill" onto the worksheet into a...Read more

Recent Articles

Formula challenge - list names by teams

In the worksheet shown, the goal is to list the names associated with each team, based on the data in columns B and C. The result should be a list of team members separated by commas. The solution should be dynamic. If the data changes, the result should update accordingly.

This challenge assumes you are using Excel 2021 or later. 

...Read more
Thanks for the resources you provide. I've bumped into it as an avid Excel user (not at your level though) and have immediately seen the value - wow.
Antonie
Thanks for you website. I've learned a lot from a variety of resources but yours is a favorite. I've made some great strides while I'm rewriting a spreadsheet that has portions that goes back 20+ years, mostly in the use of arrays in OFFICE 365.
Gregory
Brilliant page! Thank you for always helping me whenever I am stuck! Keep doing the good work, much grateful!
Richa

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