×

Excel Formulas

Calculate Quarter & FY Totals With Single Excel Function

Calculate Quarter & FY Totals With Single Excel Function

Excel Function To Provide Quarter and Full Year Totals I've been on a custom function blitz ever since I learned...

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...

Does Cell Contain Upper Or Lower Case Character Formula

Does Cell Contain Upper Or Lower Case Character Formula

Text Detection Formulas In Excel Microsoft Excel is a powerhouse for anyone who loves to crunch numbers and juggle data....

Quickly Create A Dynamic Named Range in Excel

Quickly Create A Dynamic Named Range in Excel

What Is a Dynamic Named Range? A dynamic Named Range in Excel is a powerful feature that allows you to...

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...

Excel Formula To Find Any Special Character

Excel Formula To Find Any Special Character

Is There A Formula to Find Special Characters in Excel? There are a few different ways you can approach determining...

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...

4 Formulas That Can Return An Excel Tab's Name

4 Formulas That Can Return An Excel Tab's Name

Formula To Determine Current Sheet's Name In the vast world of Microsoft Excel, users often find themselves delving into intricate...

[Solved] Excel Found A Problem With Formula References In This Worksheet

[Solved] Excel Found A Problem With Formula References In This Worksheet

How To Troubleshoot This Persistent Error Message Not this dialog box again! If you are reading this article, you have...

How The Heck Do You Use Excel's Lambda Function? [Guide]

How The Heck Do You Use Excel's Lambda Function? [Guide]

Are you ready to dive into the magical world of Excel's Lambda function? Whether you're a seasoned Excel wizard or...

VLOOKUP Practice Example File [With Solutions]

VLOOKUP Practice Example File [With Solutions]

What Is Vlookup? Vlookup stands for Vertical Lookup and is part of a group of functions that I like to...

Excel's Offset Function: Easily Understand It!

Excel's Offset Function: Easily Understand It!

Overview Of The OFFSET function Welcome to my tutorial on one of Excel's powerful and versatile functions - OFFSET! Excel's...

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...

How To Calculate A CAGR Formula In Excel (Correctly)

How To Calculate A CAGR Formula In Excel (Correctly)

Interactive Excel CAGR Calculator Tool If you are looking for a way to quickly calculate a CAGR for a PowerPoint...

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...

Calculating Picture Frame Spacing in Excel (Inches)

Calculating Picture Frame Spacing in Excel (Inches)

The Chore of Hanging Pictures Often times when I find myself needing to hang multiple picture frames next to each...

Dynamically Reference Excel Tables Inside A Vlookup Function

Dynamically Reference Excel Tables Inside A Vlookup Function

In this article, we are going to explore how to reference a specific Excel Table object from a drop-down list...

How To Pull Cryptocurrency Prices In Excel

How To Pull Cryptocurrency Prices In Excel

Cryptocurrencies Now In Excel! When Excel received the capability to retrieve stock data directly within the spreadsheet via data types,...

All About Excel's New LET Function

All About Excel's New LET Function

Excel has released a new function in 2020 that will allow you to define variables within the scope of the...

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...

Add Real-Time Stock Prices And Metrics To Excel

Add Real-Time Stock Prices And Metrics To Excel

We Finally Got It! On June 5th, 2019 Microsoft released a feature to Office 365 that allows Excel users to...

Find And Break All External Links In Excel File [Guide 2022]

Find And Break All External Links In Excel File [Guide 2022]

How To Break External Links So you're on a mission to break/remove external links from your Excel workbook, huh? Seems...

Use Yahoo! Finance To Pull Stock Information Into Excel

Use Yahoo! Finance To Pull Stock Information Into Excel

WARNING!!! As of Q3 2017, the Yahoo! Finance capabilities in Excel have been disabled (by Yahoo!, after Verizon bought them)....

Combining Text With The CONCAT and TEXTJOIN Excel Functions

Combining Text With The CONCAT and TEXTJOIN Excel Functions

Hey everyone! Chris here and I want to introduce you to a new Excel blog called Spreadsheeto. Bloggers Mikkel and...

Formulas To Calculate Longest & Current Win Streaks

Formulas To Calculate Longest & Current Win Streaks

All About The Wins As we start to head into the summer months here in the United States, I thought...

Why Does Excel Say Cell Values Are Not Equal When They Are?

Why Does Excel Say Cell Values Are Not Equal When They Are?

What's Wrong With Excel? I try to get on the Mr. Excel forums a few times a week and this...