Recent Posts

Using the standard AVERAGE function with data that contains zeros can give you an incorrect average. Instead, we can use the AVERAGEIF...

Formatting names can be a manual and slow process. Here is a quick method to turn a middle name into a middle initial when given a full...

Often, you'll receive a list of first and last names combined into a full name and need to separate them. Here's a quick method to easily...

Often, you'll receive a list of names broken up into two separate columns, first and last, and need to combine them into a full name....

A lot of time spent in Excel is used to clean up data that may not be immediately useful into something valuable. Being able to break up...

A 3-D reference is a reference to a range of cells across multiple worksheets in a workbook. For example, if you have a workbook with...

A quick way to return the number of days in any given month using a formula. Contents: Formula Explanation Formula = EOMONTH(date,0) -...

Here is a quick formula that will allow you to return the end of the month from any date in Excel. Contents: Formula Explanation Example...

Here is a quick formula that will allow you to return the beginning of the month from any date in Excel. Contents: Formula Explanation...

When working in Excel, often times you'll want to be pulling a lot of information automatically from dates. There are a couple different...

When working in Excel, often times you'll want to be pulling a lot of information automatically from dates. There are a few different...

When working in Excel, often times you'll want to be pulling a lot of information automatically from dates. There are a few different...

When doing any work with dates in Excel, often times you'll want to be able to split up your date into separate quarters. There is no...

How to find the index of the rightmost column in any table or array that has a cell matching a specified value. Contents: Formula...

Contents: Formula Explanation Example - Rounding Dates to First of the Nearest Month Formula = EOMONTH(date, (DAY(date) >...

When working in a workbook with a lot of different tabs, being able to pull, reference, and use specific sheet names can save you a lot...

How to sum across multiple dynamic arrays in a dynamic, flexible formula using the BYROW and LAMBDA Functions.

When copying workbooks, sometimes Pivot Tables/Caches Won't update and link properly, here's a work around.

How to add, subtract, multiply, and divide any size range without the need to create extra columns. All with paste.