it's an array formula:
{=SUM(IF(ISERROR(FIND(CONCATENATE("|",A4,"|"),$B$1:$B$3)),0,1))}
which counts the occurrences of a series of substrings (here A4 surrounded by
"|"s) in an array of cells ($B$1:$B$3)
Zitat von Vijayakumar Gowdaman <[email protected]>:
> Can you send the actual formula you are trying to evaluate. I have managed
> to implement the functionality to handle the formulas
> which is oututputting an array, something like creating a matrix.
>
> One thing I couldn't manage to do is if the formula itself an array
> formula i.e; ={formula...}
>
> Regards,
>
> Vijayakumar Gowdaman
>
>
>
> Alexander Hörnlein <[email protected]>
> 14/01/2010 10:26
> Please respond to
> "POI Users List" <[email protected]>
>
>
> To
> [email protected]
> cc
>
> Subject
> HSSF: array formulas
>
>
>
>
>
>
>
> hi all,
>
> (sorry i am new to this list, so if i'm doing something wrong, point
> me to faq, how-to, better suited lists, etc.)
>
> is there any way to make array formulas work in hssf? i know it's not
> supported but the bug/issue
> (https://issues.apache.org/bugzilla/show_bug.cgi?id=46989) is dated
> 2009-04-07 with no updates since. any nightly/experimental builds,
> patches? or some undocumented approach?
>
> best regards,
> alexander
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [email protected]
> For additional commands, e-mail: [email protected]
>
>
>
>
>
> ---
>
> This e-mail may contain confidential and/or privileged information.
> If you are not the intended recipient (or have received this e-mail
> in error) please notify the sender immediately and delete this
> e-mail. Any unauthorized copying, disclosure or distribution of the
> material in this e-mail is strictly forbidden.
>
> Please refer to http://www.db.com/en/content/eu_disclosures.htm for
> additional EU corporate and regulatory disclosures.
