View Single Post
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default Suppress array formula #NA

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

--
Regards,

Peo Sjoblom

(No private emails please)


wrote in message
oups.com...
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(NameLis t))

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

Regards,

Stefano