Featured Formulas

Random list of names

In this example, the goal is to create a list of 10 random names from a larger list of 100 names. In other words, we want to select a random subset of names from a larger list. The names to select from are in column B, starting in row 5. The formula should handle any number of...Read more

Featured Functions

FILTER Function

The FILTER function "filters" data based on one or more conditions, and extracts matching values. The conditions are provided as logical expressions that test the source data and return TRUE or FALSE. The result from FILTER is an array of matching values from...Read more

Recent Articles

I just wanted to thank you immensely for all the amazing information that you have been sharing. I have been undertaking a quite complex data analysis work and had to search quite often for answers on the internet but INEVITABLY I end up being redirected to your site where almost magically I always find what I am looking for. Even when I feel completely stuck, here the answer from you comes ... I wish I could express how grateful I am for such an amazing service that you are offering to the world. Certainly the number ONE source of help for Excel users ...
Giulio
Thanks for this site. It really is quick and to the point. Each article gives the information you need to solve the problem without excessive descriptions that you usually have to skim through. Keep up the great work!
Pernilla
Just did a quick google on a question about Excel and Boom....up popped the link to your site. My solution was found and implemented within minutes, and I had one of those "running around the office" moments (we've all been there!). Some great information on there...Thanks & keep up the good work!
Phil

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