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

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 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 in a dynamic, flexible formula using the BYROW and LAMBDA Functions.