View Single Post
  #1   Report Post  
 
Posts: n/a
Default Suppress array formula #NA

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