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:
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