Hi - Dave here.
Happy Friday!
10 years ago, Lisa and I started Exceljet!
Our goal was to help ordinary people get things done in Excel by providing useful information in a way that is quick, clean, and to the point.
Today, Exceljet serves more than a million users a month. What a crazy ride it's been. These days, we find ourselves competing in a world flooded with unhelpful (but well-written!) AI-generated content. I am happy to report that we are still 100% human :)
Thank you sincerely for your support!
Ten years is a big achievement. To celebrate, we're having an anniversary sale. All of our video courses and bundles are 30% off through Black Friday. Plus, we'll ship you a free shortcut card anywhere in the world with all orders of $50 or more.
Example-based training
Our training is based on the idea that you must learn by doing. To make learning easy, our videos are short (about 3 minutes) and include a practice worksheet. That way, you can watch a video and practice a new skill in about 5 minutes. In addition, all Exceljet training is lifetime access with no expiration date.
To see details about the training we offer, and to automatically get the special anniversary sale discount, just click the special link below:
https://exceljet.net/training/bundles?code=10YEARS
You will see the discounted price on the checkout page. The best value overall is Bundle #4, which contains all courses (over 450 videos) and includes a free additional user.
The sale ends at midnight US Pacific time on Friday, November 24.
More SORTBY!
In my last email, I explained how to sort with a substring using the SORTBY function. Near the end of the article, I added an example to sort data like "City, State, ZIP" by State. I've now updated the article to extend this approach to sort by State first and
then by City. In the screen below, the formula in cell D5 is:
=LET(
data,B5:B16,
states,TEXTBEFORE(TEXTAFTER(data,", ")," "),
cities,TEXTBEFORE(data,","),
SORTBY(data,states,1,cities,1)
)
This idea came from reader Matt Hanchett. In addition to illustrating how SORTBY can be used to sort on two levels, it is also a nice demo of how the LET function can make a formula easier to read and understand.
[
Read the article and download the workbook here]
Read the complete explanation and download the workbook at the link above.
Have a great weekend!
Dave
