| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using INDEX function to return array row.
Hi,
if using INDEX to return an array (the row is an array), then you need to enter it as an array formula. For example, if your data has 4 columns, select A20:D20, enter the formula: =INDEX(A1:D10,2,) commit with Shift+Ctrl+Enter. Now, all cells A20:D20 will contain the 2nd row of A1:D10. Does this help? Kostis Vezerides |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Match function with duplicate values in an array | Excel Worksheet Functions | |||
| Need some comments on my Utility_Move class module. | Excel Worksheet Functions | |||
| Public Function - Color Index | Excel Worksheet Functions | |||
| VBA function for "Mean" using Array as argument | Excel Worksheet Functions | |||
| Formatting result of Index function | Excel Worksheet Functions | |||
Threaded Mode
