Featured Formulas

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 range...Read more

Recent Articles

I would highly recommend that anyone seeking Excel advice turn to this resource as their first stop. You can spend hours on Google trying to find a way to do something and get nowhere, at Exceljet I tend to find the answer very quickly and it is easily implemented.
Tony
This tip is award winning! Thank you!!
Eileen
I love to use excel and use it a lot in my work. Your tips, tricks and examples have helped me enormously.
Lisa

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