XL: Using Noncontiguous Ranges in Array Functions (79625)
The information in this article applies to:
- Microsoft Excel 2000
- Microsoft Excel 2002
- Microsoft Excel 97 for Windows
This article was previously published under Q79625 For a Microsoft Excel for the Macintosh version of this article, see 181867.
SUMMARY
Microsoft Excel functions that take arrays as arguments, such as
LINEST, LOGEST, IRR, MIRR, MDETERM, NPV, RATE, and XIRR cannot accept
noncontiguous ranges of data as their array arguments. This article provides two methods to work around this behavior.
Modification Type: | Major | Last Reviewed: | 5/13/2003 |
---|
Keywords: | kbhowto KB79625 |
---|
|