TutorialHow to Convert Large Decimal Numbers to BinaryThere 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...
TutorialHow to Unstack Uneven Data From a List in ExcelWhile 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...
TutorialHow to Sum Cells By Color in ExcelWhile 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...
TutorialHow to Count Colored Cells in ExcelWhile not a built-in Excel feature, we can create our own function to easily count colored cells. Contents: 1. How to Use VBA User...