Featured Formulas

If cell begins with x, y, or z

The goal is to take a specific action when a value begins with "x", "y", or "z". As is often the case in Excel, there are multiple ways to approach this problem. The simplest way is to use the OR function with the LEFT function to create the required logical test. Another option is to...Read more

Featured Functions

REGEXREPLACE Function

The REGEXREPLACE function replaces text matching a specific regex pattern in a given text string. You can think of REGEXREPLACE as a much more powerful version of the simplistic SUBSTITUTE function. While both functions can be used to search and replace simple text strings, REGEXREPLACE can...Read more

Recent Articles

Formula challenge - list names by teams

In the worksheet shown, the goal is to list the names associated with each team, based on the data in columns B and C. The result should be a list of team members separated by commas. The solution should be dynamic. If the data changes, the result should update accordingly.

This challenge assumes you are using Excel 2021 or later. 

...Read more
Great pages. I search for solution, find it. Another week, search for solution, find it again.
Hans
What a great website. I'm an Excel trainer and your website helped me populate a sample company worksheet with random departments. Thanks.
Lloyd
I really appreciate your delivery of the videos, the clean and sharp documentation and pleasant to the eye website, uncluttered, direct, short and snappy. From what I've checked out elsewhere nothing compares...
Christina

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