Posts: n/a

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
array formula	Jonathan Cooper	Excel Discussion (Misc queries)	4	September 9th 05 12:27 PM
referencing the value of a cell containing an array formula	KR	Excel Worksheet Functions	4	July 5th 05 06:15 PM
problem with Array Formula	OrdOff	Excel Worksheet Functions	2	June 30th 05 04:57 PM
Trouble shooting#NA error in Array formula	RonR	Excel Discussion (Misc queries)	2	June 14th 05 09:58 PM
Match / Vlookup within an Array formula	Hari Prasadh	Excel Discussion (Misc queries)	3	February 3rd 05 04:37 PM

All times are GMT +1. The time now is 10:59 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us