Featured Formulas

Get information about max value

An interesting problem in Excel is how to look up information related to the maximum value in a set of data. For example, if you have a dataset of property listings and prices, you might want to find details about the property with the highest price. The best way to solve this problem...Read more

Featured Functions

STOCKHISTORY Function

The STOCKHISTORY function retrieves historical stock price information based on a given symbol and date range. The main purpose of STOCKHISTORY is to get the history of a financial instrument over time. Although the name suggests that STOCKHISTORY is meant to work only with stocks,...Read more

Recent Articles

I have just come across your website and within minutes of looking around I can confidently say that had I discovered this sooner, I would have saved myself many many hours of formula troubleshooting over the last several years. Very clear explanations for some fairly tricky problems I have been faced with and all incredibly easy to find!
Andy
You have saved me HOURS of work. Thank you so much!!!!
Jennifer
Just wanted to say that in general, I love Exceljet and use it routinely for work, building out formulas. I just tried your chatbot and it was great!
Bem

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