Featured Formulas

Random numbers without duplicates

In this example, the goal is to generate a list of random numbers without duplicates. This involves jumping through a few hoops because although the RANDARRAY function can easily generate a list of random integers, there is no guarantee that the numbers will be unique. In the explanation below,...Read more

Featured Functions

IFERROR Function

The IFERROR function returns a custom result when a formula returns an error and a normal result when a formula calculates without an error. The typical syntax for the IFERROR function looks like this:

=IFERROR(formula,custom)...Read more

Recent Articles

I am a passionate Excel user, and a passionate reader of your site. Even if I am considerate a (moderate) expert (well, I know how to use xlookup, filter, to perform some conditional formatting; this qualifies me as a wizard) your site is the first that I ever mention. I have never found explanations more clear or detailed than yours, you dig inside formulas, you never lose focus to final goal of the formula, you are truly masters of formation.
Paolo
I continue to love receiving these emails. I’ve never seen this one before. I do think this is useful and I’m sure I’ll find a need for it going forward in my excel usage. Once again, thanks for sharing. You ARE making a difference.
Shane
Just wanted to thank you for your fantastic site. I use the site many times a week and it has helped me to solve many reporting problems and needs I have in my daily work. I have learned many new ways to use excel thanks to you.
Sanna

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