Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RBI RBI is offline
external usenet poster
 
Posts: 1
Default Using INDEX function to return array row.

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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 751
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using Match function with duplicate values in an array Richard Excel Worksheet Functions 3 April 22nd 23 08:45 PM
Need some comments on my Utility_Move class module. jchen Excel Worksheet Functions 0 August 21st 06 08:05 PM
Public Function - Color Index carl Excel Worksheet Functions 3 April 7th 06 09:08 PM
VBA function for "Mean" using Array as argument ASokolik Excel Worksheet Functions 21 March 28th 06 11:05 PM
Formatting result of Index function ExcelFred Excel Worksheet Functions 5 July 26th 05 02:34 PM


All times are GMT +1. The time now is 11:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"