Microsoft Office Tutorials and References
In Depth Information
Returning nonblank cells from a range
The following formula is a variation on the formula in the preceding section. This array formula works with a
single-column vertical range named Data. The array formula is entered into a range of the same size as Data
and returns only the nonblank cell in the Data range.
For compatibility with versions prior to Excel 2007, use this formula:
Reversing the order of cells in a range
In Figure 15-13, cells C4:C13 contain a multicell array formula that reverses the order of the values in the range
A4:A13 (which is named Data ).
The array formula is
Search JabSto ::

Custom Search