Microsoft Office Tutorials and References
In Depth Information
Figure 15-14: A multicell array formula displays the values in column A, sorted.
Returning a list of unique items in a range
If you have a single-column range named Data, the following array formula returns a list of the unique items in
the range (the list with no duplicated items):
This formula doesn't work if the Data range contains any blank cells. The unfilled cells of the array formula dis-
play #NUM!.
Search JabSto ::

Custom Search