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

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

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

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

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

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

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

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

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

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

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

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