Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I,m trying to use the index function to return an entire row of data from an
array of mixed text and numbers. According to the help system entering the function without a column reference should return the entire row. "If array has more than one row and more than one column, and only row_num or column_num is used, INDEX returns an array of the entire row or column in array." I can not make this work. The best I can do is get a single value. Does anyone have any experience using the INDEX function to return an array row? Thanks, |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |