Archive for ROWS function
Rearrange cells in a cell range to vertically distributed values
The formula in cell B8 uses a named range to calculate the row and column needed to extract the correct […]
The ROWS function allows you to calculate the number of rows in a cell range. The example above shows that cell […]
Here comes another post about the MMULT function, today I made a dynamic scoreboard. There are five women competing and there […]
5 easy ways to VLOOKUP and return multiple values
This post explains how to lookup a value and return multiple values. No array formula required.
