Microsoft Office Tutorials and References
In Depth Information
The following modified version eliminates the #NUM! display by using the IFERROR function, introduced in
Excel 2007:
{=IFERROR(INDEX(Data,SMALL(IF(MATCH(Data,Data,0)=ROW(INDIRECT
(“1:”&ROWS(data))),MATCH(Data,Data,0),””),ROW(INDIRECT
(“1:”&ROWS(Data))))),””)}
Figure 15-15 shows an example. Range A4:A22 is named Data , and the array formula is entered into range
C4:C22. Range E4:E23 contains the array formula that uses the IFERROR function.
Figure 15-15: Using an array formula to return unique items from a list.
Displaying a calendar in a range
Search JabSto ::




Custom Search