## Excel TEXTBEFORE TEXTAFTER Functions

Learn to properly use the Excel TEXTBEFORE and TEXTAFTER functions. There is a cool trick you can use with these functions to get the outcome you want. Check out the post for more.

October 24th, 2022|Categories: Dynamic Arrays, Formulas|Tags: , , |

## Excel VSTACK Function

This is a real-life example of Excel's VSTACK function. Quickly stack data from multiple sheets (even as many as 15 sheets!), filter out blank cells and even sort the summary table.

May 27th, 2022|Categories: Dynamic Arrays, Features||

## Excel TEXTSPLIT Function

Excel's TEXTSPLIT function can split words into separate cells. You can have multiple delimiters, you just have to know how to define these properly. You can also do amazing things like splitting into columns and rows and internally sorting words.

March 31st, 2022|Categories: Dynamic Arrays, Formulas|Tags: , , , |

## New Excel Functions Vstack Textsplit tocol

Excel recently released a set of new functions like VSTACK, TEXTSPLIT and TOCOL that will have you looking forward to working with complex files and data because your life just got more exciting (at least mine did!).

March 31st, 2022|Categories: Dynamic Arrays, Formulas||

## Excel SCAN Function

Learn how to use the new Excel SCAN function! This function is a Lambda helper function. You can use it to "scan" a range and apply a calculation to each cell. In this example you'll learn how to use SCAN to get to-date values and how you can tweak it to return YTD values.

November 5th, 2021|Categories: Dynamic Arrays, Formulas|Tags: , , , , |

## Excel – Switch Columns Multiple Values

Pivoting columns in Excel is a common task when cleaning and organizing data. Sometimes you have a complex scenario where you have multiple values when switching columns. You'll have to combine these multiple values into one cell. I'll show you 3 methods to get this done.

## Excel Remove Duplicates

These are 3 easy ways to remove duplicates in your data to create a unique or distinct list of values in Microsoft Excel. It's a very common task for data cleaning and also a very common job interview question... BUT one of the methods returns a different result. Make sure you understand why.

July 28th, 2021|Categories: Dynamic Arrays, Features, Power Query & Power Pivot||

## Excel Generate Random Numbers

This tutorial shows you different methods to generate random numbers in Excel (including no repeats). You might need random numbers if you're preparing test data. Or if you need to share your files with consultants and have to replace official values with random ones.

June 24th, 2021|Categories: Dynamic Arrays, Formulas||

## Excel SPILL Error

What is the Excel Spill error and how can you fix it? Sometimes it's obvious but sometimes it's not clear why you get this error. Find out why and how to fix it in this article.

January 14th, 2021|Categories: Dynamic Arrays, Formulas|Tags: , , |