Suppress array formula #NA

[[email protected]]

Hello,

I'm trying to stop the #NA error from an array formula but can't get
it.

The formula is =if(ISNA(TRANSPOSE(NameList)),"",TRANSPOSE(NameList))

The formula is entered as an array across 15 cells. Any solutions?

Regards,

Stefano

[Peo Sjoblom]

Works for me, do you enter it with ctrl + shift & enter?

--
Regards,

Peo Sjoblom

(No private emails please)


<[email protected]> wrote in message
news:[email protected]...
> Hello,
>
> I'm trying to stop the #NA error from an array formula but can't get
> it.
>
> The formula is =if(ISNA(TRANSPOSE(NameList)),"",TRANSPOSE(NameList))
>
> The formula is entered as an array across 15 cells. Any solutions?
>
> Regards,
>
> Stefano
>

[[email protected]]

Yes I did. Could the problem be that the name, "NameList" is another
array that sorts names to the top of the list with no blanks? I believe
I got that array from C. Pearson's website. Yes, the formula works if
NameList is a list of typed in names, but not when getting the list
from another array. Or could it also be that the array formula entered
is not the same size as the range name, "NameList"? NameList expands
and contracts automatically.

Regards,

Stefano

[Aladin Akyurek]

[email protected] wrote:
> Yes I did. Could the problem be that the name, "NameList" is another
> array that sorts names to the top of the list with no blanks? I believe
> I got that array from C. Pearson's website. Yes, the formula works if
> NameList is a list of typed in names, but not when getting the list
> from another array. Or could it also be that the array formula entered
> is not the same size as the range name,

Yes.

> "NameList"? NameList expands
> and contracts automatically.

If that's the case you need a different approach. Maybe you could post a
small sample along with the desired output.

[[email protected]]

Thanks, but I just made the arrays the same size all the time and that
takes care of it.

Regards,

Stefano