Microsoft Office Tutorials and References
In Depth Information
Using Single-Cell Array Formulas
Figure 14-13: The goal is to count the number of characters in a range of text.
Then, you use a SUM formula to calculate the sum of the values returned by the intermediate
The following array formula does the job without using any intermediate formulas:
The array formula uses the LEN function to create a new array (in memory) that consists of the
number of characters in each cell of the range. In this case, the new array is
The array formula is then reduced to the following:
Summing the three smallest values in a range
If you have values in a range named Data , you can determine the smallest value by using the
SMALL function:
You can determine the second smallest and third smallest values by using these formulas:
Search JabSto ::

Custom Search