Array Formula

[ra@SCM]

I have an array function that fits in one cell, but when I 'run' it, it generates an array that is 3 rows x 1 column. How do I get Excel to return only the 3rd item, but still keep the array formula intact? Thanks, in advance.

(The reason I want to do this is because the array is generated by a third-party application that has custom formulas.)

[MrShorty]

Use the INDEX function. =INDEX(yourarrayformula(),3,1)

[dilipandey]

HI Ra@SCM,

Could you upload a sample workbook....?

Regards,
DILIPandey

<click on below 'star' if this helps>

[ra@SCM]

Tried the INDEX function, but it won't work...it just returns a #REF error...the array formula is not generating an array inside of the index function is my best guess.

[MrShorty]

According to Excel's built in help files, "Row_num and column_num must point to a cell within array; otherwise, INDEX returns the #REF! error value." Are you certain that your array formula is returning a 3x1 array? Is it possible it is returning a 1x3 array or some other configuration?

You might try =index(yourarrayformula(),3). According to help, when the input array is 1 column wide (or 1 row tall), you don't need both rownum and columnnum arguments.