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):
{=INDEX(Data,SMALL(IF(MATCH(Data,Data,0)=ROW(INDIRECT
(“1:”&ROWS(Data))),MATCH(Data,Data,0),””),ROW(INDIRECT
(“1:”&ROWS(Data)))))}
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