OhPack function

Hi, I've a question about filtering null values in a vector. OhPack funcion works if the null values are in the bottom part of the vector: can quantlibXL handle the more general case of null values in arbitrary positions? (e.g. [1,2,#N/A,4]?
Thx for your help,
Stefano

---------- Initial Header -----------

>From      : [hidden email]
To          : [hidden email]
Cc          :
Date      : Mon, 10 May 2010 14:41:46 +0000
Subject : QuantLib-users Digest, Vol 48, Issue 10

> Send QuantLib-users mailing list submissions to
> [hidden email]
>
> To subscribe or unsubscribe via the World Wide Web, visit
> https://lists.sourceforge.net/lists/listinfo/quantlib-users
> or, via email, send a message with subject or body 'help' to
> [hidden email]
>
> You can reach the person managing the list at
> [hidden email]
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of QuantLib-users digest..."
>

------------------------------------------------------------------------------

_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users

[Ferdinando M. Ametrano-3]

On Wed, May 12, 2010 at 2:51 PM, stefano sampietro
<[hidden email]> wrote:
> Hi, I've a question about filtering null values in a vector. OhPack funcion works if the null values are in the bottom part of the vector: can quantlibXL handle the more general case of null values in arbitrary positions? (e.g. [1,2,#N/A,4]?

The rational behind ohPack is that you might have an array formula
result which is smaller than the function's Excel range.
If you want that range to be an input to another function you have to
trim #N/A at the bottom and on the right.

What do you want is different, and it is not available yet

ciao -- Nando

------------------------------------------------------------------------------

_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users

ok, I understand

thx
Stefano

---------- Initial Header -----------

>From      : [hidden email]
To          : "stefano sampietro" [hidden email]
Cc          : "quantlib-users" [hidden email]
Date      : Wed, 12 May 2010 15:13:23 +0200
Subject : Re: [Quantlib-users] OhPack function

> On Wed, May 12, 2010 at 2:51 PM, stefano sampietro
> <[hidden email]> wrote:
> > Hi, I've a question about filtering null values in a vector. OhPack funcion works if the null values are in the bottom part of the vector: can quantlibXL handle the more general case of null values in arbitrary positions? (e.g. [1,2,#N/A,4]?
>
> The rational behind ohPack is that you might have an array formula
> result which is smaller than the function's Excel range.
> If you want that range to be an input to another function you have to
> trim #N/A at the bottom and on the right.
>
> What do you want is different, and it is not available yet
>
> ciao -- Nando
>

------------------------------------------------------------------------------

_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users