Excel Tips
Excel 2024: Split Text into Words Using TEXTSPLIT »
October 18, 2024
Many people had been asking for TEXTSPLIT. It was one of the most popular requests on the Excel UserVoice site. I often used a three-line User-Defined Function from Excel MVP Brad Yundt to create a function to split text into words.
Excel 2024: Text Before or After a Specific Delimiter »
October 15, 2024
The new TEXTBEFORE and TEXTAFTER functions debuted on March 16, 2022 for Microsoft 365 Insiders. These functions isolate the text before or after a specific delimiter.
Excel 2024: Find Largest Value That Meets One or More Criteria »
October 11, 2024
One of the new Office 365 functions added in February 2016 is the MAXIFS function. This function, which is similar to SUMIFS, finds the largest value that meets one or more criteria: You can either hard-code the criterion as in row 7 below or point to cells as in row 9. A similar MINIFS function finds the smallest value that meets one or more criteria.
Excel 2024: New LAMBDA Helper Functions »
October 9, 2024
About a year after LAMBDA was introduced, Microsoft realized that we needed some helper functions. They gave us MAP, REDUCE, SCAN, MAKEARRAY, BYROW, BYCOL, and ISOMITTED.
Excel 2024: Combining Subformulas into a Single Lambda »
October 7, 2024
Often, I will need a complicated formula. It is easier to build that formula in tiny steps. Once the subformulas are working, you can try to combine everything into one complicated formula.
Excel 2024: Store Complex Formula Logic in LAMBDA function »
October 3, 2024
Excel has a great formula language with hundreds of built-in calculations, but it doesn't have functions for every possible calculation. A new research project from Microsoft's Calc Intelligence team in England will allow you to create your own functions.
Excel 2024: Use the LET Function to Re-Use Variables in a Formula »
October 1, 2024
The LET function debuted during 2020 for Microsoft 365 Subscribers. There are all sorts of calculations in Excel that can benefit from re-using an intermediate calculation.
Excel 2024: Python for K-Means Clustering of Excel Data »
September 27, 2024
Lately, I've been exercising every day in a Meta Quest virtual reality headset, using a game called Supernatural. There are several communities of Supernatural fans who create quests and challenges while playing Supernatural. A quick shout-out to my friends at ABSN - Adventures by Supernatural Ninjas.
Excel 2024: Using Python in Excel »
September 25, 2024
This article will talk about Python from an Exceller's perspective. I am definitely a Python rookie. But I found useful things that I could do with Python that I could not do in Excel.