Featured Formulas

Dynamic array

Filter by column, sort by row

To filter a set of data by a column heading, then sort the result by row, you can use a formula based on the FILTER and SORT functions. In the example shown, the formula in I5 is: =SORT(FILTER(B5:G15,(B4:G4="group")+(B4:G4=J4)),2,-1) This formula …Read more

More Formulas

Featured Videos

More Videos

Featured Functions

Dynamic array

SEQUENCE Function

The Excel SEQUENCE function generates a list of sequential numbers in an array. The array can be one dimensional, or two-dimensional, determined by rows and columns arguments. Read more

More Functions

Recent Articles

More Articles

Topics By Category

Formulas

Shortcuts

Functions

User Testimonials

I use your site almost daily. All your content is extremely helpful, clear, and easy to follow.
Joyce
Your site comes up all the time in google with my excel questions. I really like the simple layout and process to answer my questions - and most every time I find what I need to help me with my work. I also like the similar answers that appear at the bottom because I find solutions there too. much appreciated!
Brian
Appreciate your website as a guide to trying to solve challenges. I use regularly as needed and generally find the basics I need to build formulas. It's magnificent and I just want to say thanks.
Rean
More Testimonials

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