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
|