Thread: [Solved] Complex array formula
View Single Post
 
Old 02-02-2012, 06:56 AM
andrei andrei is offline Windows 7 32bit Office 2007
Novice
 
Join Date: Sep 2011
Posts: 14
andrei is on a distinguished road
Default Re: Complex array formula

Hello Colin,

When carefully looking at the N function, although the result it is not an ERROR value, it is not a correct value either. N function does not return a range as needed in my example, but rather a value as you can see in the attached file.

It seems that N is not the proper function for this issue...

Andrei
Attached Files
File Type: xlsx Sample_data_.xlsx (16.0 KB, 13 views)
Reply With Quote