Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extension to Excel INDEX function
I suggest an extension to INDEX (array format), such that it allows a limited
range to be returned, as follows: =INDEX(array, row, column, [height], [width]) I am frequently having to return part of an array, and the above functionality can only currently be done using OFFSET, as follows: =OFFSET(reference,0,0,height, width) However, OFFSET is pretty nasty - you lose the ability to trace dependencies. It makes loads more sense to use INDEX for this - I only want to work within the array, not offset it. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting result of Index function | Excel Worksheet Functions | |||
Excel 2003 Slow Function Argument Window | Excel Discussion (Misc queries) | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
Excel Sort function should not sort the cell formatting! | Excel Worksheet Functions | |||
Access Module coded converted to Excel Function | Excel Discussion (Misc queries) |