Excel. Access single value from array function

Question

I have a custom function in Excel 2007. It returns array of doubles.

Dim ResultArray(10) As Double

If I use it with Ctrl-Shift-Enter I get 10 results in a row.

I want to access a particular resut within the result array.

Say second result. I'd expect something like =myFn(a,b,c)(2) but it doesnt work....

Is it possible?

Is it (2) or [2] .. array syntax is different in any language. Also I think you should try varA = myFn(a,b,c) and then do varA(2) (or varA[2]). Finally, you could write a second function with an extra parameter as index of the double you actually want. — Jochem
– Jochem, Commented Nov 14, 2010 at 16:14
Actually, myFn(a,b,c)(2) is perfectly valid VBA syntax, but as your accepted answer states, the Excel worksheet function to use is INDEX. — jtolle
– jtolle, Commented Nov 14, 2010 at 19:44

jon_darkstar · Accepted Answer · 2010-11-14 16:14:35Z

8

Use the Index function to get certain element of Array.

=Index(myFn(a,b,c); 2)

answered Nov 14, 2010 at 16:14

jon_darkstar

16.9k7 gold badges35 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

or maybe comma instead of semicolon? semicolon works in openoffice

semicolon is used as separator instead of comma in various locales, especially in Slavic ones