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

How to Sum Cells By Color in Excel

While not a built-in Excel feature, we can create our own function to easily sum cells by color. Contents: 1. How to Use VBA User Defined...

How to Count Colored Cells in Excel

While not a built-in Excel feature, we can create our own function to easily count colored cells. Contents: 1. How to Use VBA User...