Microsoft Office Tutorials and References
In Depth Information
Figure 15-12: Using an array formula to return only the positive values in a range.
This modified array formula, entered into range E4:E23, uses the IFERROR function to avoid the error value
display:
{=IFERROR(INDEX(Data,SMALL(IF(Data>0,ROW(INDIRECT(“1:”&ROWS(Data)))),
ROW(INDIRECT(“1:”&ROWS(Data))))),””)}
The IFERROR function was introduced in Excel 2007. For compatibility with older versions, use this formula
entered in G4:G23:
Search JabSto ::




Custom Search