Author Topic: Return array  (Read 1536 times)

co3nan

  • Newbie
  • *
  • Posts: 1
  • Karma: +0/-0
    • View Profile
Return array
« on: June 15, 2012, 07:10:39 AM »
Hi everybody
when I write a function returning an array it doesn't work.
I expect the function returns a grid of data but it returns a single cell value and not a list of list as return values.
Also I can not work with standard function examples as array_pyxll_function_2  or numpy_array_fucntion_1.
I installed numpy but the second function doesn't return the transpose matrix but only an error message. (I installed numpy correctly and numpy_is_installed() function returns true value).
Thanks in advance

Tony

  • Administrator
  • Hero Member
  • *****
  • Posts: 606
  • Karma: +14/-1
    • View Profile
Re: Return array
« Reply #1 on: June 15, 2012, 10:09:29 AM »
Hi,

are you entering it as an array formula into Excel? You have to select the range you want to use, then enter the formula, and then press Ctrl+Shift+Enter. See http://office.microsoft.com/en-us/excel-help/introducing-array-formulas-in-excel-HA001087290.aspx for details about array formulas.

Is there anything in the log that might help us figure out your second problem with those functions? Please could you take a look and copy and paste any errors, or just send me the whole file, please?

Regards,
Tony