Dynamic Arrays - TheSpreadsheetGuru

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

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

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

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

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

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

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

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

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

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

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

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

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

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