Recent Posts

How to Convert Large Decimal Numbers to Binary

There are lots of ways to convert decimal numbers into binary. 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...

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