×

Dynamic Arrays

All of Excel's Dynamic Array Functions

All of Excel's Dynamic Array Functions

The Power Of Dynamic Array Functions In the ever-evolving landscape of data analysis and spreadsheet management, Microsoft Excel has taken...

Formula to Split Excel Data into Multiple Excel Tabs (No VBA)

Formula to Split Excel Data into Multiple Excel Tabs (No VBA)

Sending Data To Different Sheets Based On Column Value Often financial business partners are faced with gathering data centrally (consolidating)...

List Duplicates or Missing Values By Comparing Two Columns In Excel

List Duplicates or Missing Values By Comparing Two Columns In Excel

Comparing Two Lists With An Excel Formula Sometimes the real world provides us with situations where we need to compare...

How To Sum Dynamic Array Function Spill Ranges

How To Sum Dynamic Array Function Spill Ranges

Different Ways to Add Together Dynamic Array Formulas If you are trying to figure out how to apply the addition...

Dynamic Array Formula Spill Ranges With Charts

Dynamic Array Formula Spill Ranges With Charts

Linking Dynamic Array Formulas into Chart Series With the introduction of Dynamic Array functions in Excel, your spreadsheets can now...

Using XLOOKUP Function's Power In VBA Macro Code

Using XLOOKUP Function's Power In VBA Macro Code

What This VBA Code Does The following VBA code will show you how to utilize the power of Excel’s XLOOKUP...

XLOOKUP Formula To Return All Matches

XLOOKUP Formula To Return All Matches

Can You Return All Matches With XLOOKUP? Currently, you cannot return multiple lookup results with Excel’s XLOOKUP function. You can...

Which Excel Versions Have XLOOKUP Function? [Solved]

Which Excel Versions Have XLOOKUP Function? [Solved]

Versions Of Microsoft Excel For XLOOKUP Function The following versions of Microsoft Excel include the XLOOKUP function: Excel 2021 or...

How To Use Wildcards/Partial Match With Excel's Filter Function

How To Use Wildcards/Partial Match With Excel's Filter Function

Filter Function and Partial Matching (Wildcard) Criteria Unfortunately, as of this writing, the Filter function does not contain an input...

4 PRO Ways to Create A Filtering Search Box [Excel Download]

4 PRO Ways to Create A Filtering Search Box [Excel Download]

Creating A Search Box In Excel It's unfortunate Excel does not have a form control search box (maybe in the...

Determine YTD Stock Growth With Excel's STOCKHISTORY Function

Determine YTD Stock Growth With Excel's STOCKHISTORY Function

Summarizing Stock Data Microsoft Excel now has some great built-in functionalities to track stocks whether it be current or historical...

Pull Historical Stock Price Data in Excel

Pull Historical Stock Price Data in Excel

Get Stock Price History Directly From Excel! Stock Prices used to be a hassle to pull into Excel. I can...

Copy/Paste A Dynamic Formula Spill Range With VBA

Copy/Paste A Dynamic Formula Spill Range With VBA

What This VBA Code Does There are a plethora of new Dynamic Array functions being released in Excel that produce...

7 Ways To Generate Unique Values List In Excel

7 Ways To Generate Unique Values List In Excel

There are many scenarios you may come across while working in Excel where you only desire unique values in a...

How To Use A Double XLOOKUP Formula

How To Use A Double XLOOKUP Formula

Have you heard of an XLOOKUP/XLOOKUP? No, I didn’t stutter in my writing….there is now such a thing as a...

How To Use Excel's XLOOKUP Function [Guide 2024]

How To Use Excel's XLOOKUP Function [Guide 2024]

On August 28th, 2019, Microsoft unveiled a new Excel function with the intent of making 3 beloved and rivaled functions...

How Pros Dynamically Resize & Fill VBA Array Variables (Multiple Scenarios)

How Pros Dynamically Resize & Fill VBA Array Variables (Multiple Scenarios)

What Are Arrays? Arrays are a variant type variable that you can use in VBA coding to store a list...