Featured Formulas

Count cells not between two numbers

The goal of this example is to count the number of values recorded over 5 days that do not fall between two numbers, a low value, and a high value. In other words, to count values that are "out of range". Note that each row, labeled A-G, has its own low and high...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

Wow, what a fantastic site! I'm bookmarking it :) I googled today to find a solution to a perplexing problem, and fortunately your post on using match and index together came up. It was exactly what I needed. Thank you so much!
Kathryn
Just wanted to drop you a short e-mail to say how useful I have found several of you video tutorials. Thank you! I really found the "Choose" function video especially useful in applying financial quarters (UK!) and this led me on to finding formulas for financial year.
Paul
I just wanted to share how great EXCELJET is! You do such a great job covering a lot of topics and explaining them simply. I appreciate all the effort that goes into it.
Ryan

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