Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 02-02-2012, 06:56 AM
andrei andrei is offline Complex array formula Windows 7 32bit Complex array formula Office 2007
Novice
Complex array formula
 
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, 15 views)
Reply With Quote
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Complex array formula Complex Find and Replace paulkaye Word 1 11-13-2011 04:23 AM
Modifying subject in Hyperlink - Complex amritr Outlook 0 05-26-2011 11:20 PM
Complex array formula Searching for Word Reformatter for Complex Docs jchapman Word 1 05-05-2011 04:50 PM
Look up an array based on user input johnsmb Excel 2 01-07-2011 01:12 PM
Complex Document Formatting rguima Word 0 02-22-2009 04:31 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:15 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft