Recent Posts

How to Convert Large Binary Numbers to Decimal in Excel

There are two good ways of converting binary to decimal. Excel has a built in function for small numbers, but you'll need a custom...

How to Unstack Uneven Data From a List in Excel

While the WRAPROWS function can be great to unstack a list with an even number of items, we'll need a custom formula to wrap, or unstack...

How to Create Index Columns Using Dynamically Spilled Arrays

Add an index column to any dynamic array using a few of the latest Excel functions for easy lookups. Contents: 1. Adding Index Column to...

How to Create a Dynamic Array of Repeating Cells

Create a repeating list based off of a range and a specific numbers of repetitions. Contents: 1. Formula 2. Explanation Formula To...

How to Return the Second to Last Item in a List in Excel

Usually, you need to return the last or first item in a list, but every once in a while, you may find yourself needing to return the...

Creating Fully Playable Yahtzee in Excel

Contents: 1. Download 2. How to Play 3. How Does it Work? 3.1 Dice Display 3.2 Rolling & Freezing Dice 3.3 Score Keeping & Entry 3.4 Turn...

How to Return the ASCII Number for Every Character in a Cell

The formulas below will take any text input and return the ASCII value of each character that comprises that string. Contents: 1....

How to Separate a Full Name Into First and Last Names in Excel

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

Finding the Rightmost Column Containing a Specific Value in a Table or Array

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

How to Remove Duplicates in Excel

Sometimes it is necessary to remove duplicate items from a column or duplicate rows out of an entire table. Removing duplicates will help...

How to use the RANDARRAY Function in Excel - 6 Examples

6 examples of how to use the RANDARRAY function in Excel from basic to advanced.

How to Sum Across Multiple Dynamic Arrays by Row in Excel

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