Rearrange values in a cell range to a single column
This article demonstrates formulas that rearrange values in a cell range to a single column. Table of Contents Rearrange cells […]

How to color chart bars based on their values
(Chart data is made up) This article demonstrates two ways to color chart bars and chart columns based on their […]

How to use the QUOTIENT function
The quotient function returns the integer portion of a division. Example, 5/2 = 2.5. The integer is 2. What's on […]

How to use the MOD function
The Mod function returns the remainder after a number is divided by a divisor. The Mod function is short for […]