Featured Formulas

Biggest gainers and losers

In this example, the goal is to display the biggest 3 gainers and losers in a set of data where Start and End columns contain values at two points in time, and Change contains the percentage change in the values. The data in B5:E16 is defined as an Excel Table...Read more

Featured Functions

RANDARRAY Function

The RANDARRAY function generates an array of random numbers between two values. The size or the array is determined by rows and columns arguments. By default, RANDARRAY returns an array of random numbers between 0 and 1. However, RANDARRAY will generate whole numbers when the...Read more

Recent Articles

Thanks for having the most informative examples of Excel queries. I use your site constantly and it's a wealth of knowledge that has saved me so much time and helped me teach colleagues to streamline their tasks also. I appreciate that you have shared your knowledge and made this available to everyone.
Patrick
Just wanted to send a quick note of thanks for everything you've put together. I needed a formula but I didn't know how to explain what I wanted, but using the quicklinks at the bottom of every page eventually got me there. I didn't even know such a formula existed, let alone a clear and in-depth description of how it works!
Maree
Whenever I need support in Excel, I search in Google. Most of the time I get a complete solution from the Exceljet. Your efforts are appreciated highly for making excel related solutions easy to understand.
Shabbir

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