PC Review


Reply
Thread Tools Rate Thread

Data validation and Arrays

 
 
Ricardo Lopes
Guest
Posts: n/a
 
      6th Mar 2010
When entering the following formula as an Array it works. But adding the same
formula to Data Validation, it displays an error. The same common error when
you enter a wrong formula in the List option.
However, if I use a cell reference instead of a table reference (not range),
it works either with the Array and the Data Validation.
This formula works for both
=OFFSET(rngStart,MATCH(tblAccount[Type],rngColumn,0)-1,1,COUNTIF(rngColumn,tblAccount[Type]),1)
This formula works for the Array only:
=OFFSET(rngStart,MATCH($C$3,rngColumn,0)-1,1,COUNTIF(rngColumn,$C$3),1)

Thanks




 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Arrays - declaration, adding values to arrays and calculation Maxi Microsoft Excel Programming 1 17th Aug 2006 04:13 PM
Arrays of Multidimensional Arrays? barmy_mad@yahoo.co.uk Microsoft C# .NET 9 22nd Mar 2006 12:15 AM
Arrays of Multidimensional Arrays? barmy_mad@yahoo.co.uk Microsoft C# .NET 0 21st Mar 2006 09:09 PM
arrays in arrays jacob Microsoft Excel Programming 4 29th Aug 2004 08:40 PM
Rectangular arrays Vs. multidimensional arrays. Nikhil Patel Microsoft C# .NET 2 21st Jul 2003 02:37 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:01 PM.