Data validation and Arrays

Discussion in 'Microsoft Excel Crashes' started by Ricardo Lopes, Mar 6, 2010.

  1. 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
     
    Ricardo Lopes, Mar 6, 2010
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Bill Manville

    Re: Excel 2003 data validation across worksheets does not work

    Bill Manville, Apr 14, 2005, in forum: Microsoft Excel Crashes
    Replies:
    5
    Views:
    659
    Guest
    Jul 13, 2005
  2. Guest

    Data Validation - In cell list drop down

    Guest, Sep 16, 2005, in forum: Microsoft Excel Crashes
    Replies:
    1
    Views:
    209
    Guest
    Sep 16, 2005
  3. Guest

    Excel data validation error

    Guest, Oct 18, 2005, in forum: Microsoft Excel Crashes
    Replies:
    0
    Views:
    213
    Guest
    Oct 18, 2005
  4. Griffey5

    Arrays in Excel

    Griffey5, Jan 6, 2008, in forum: Microsoft Excel Crashes
    Replies:
    1
    Views:
    261
    ShaneDevenshire
    Jan 6, 2008
  5. ker_01

    Data Validation error (XL2003 and XL2007)

    ker_01, Feb 18, 2010, in forum: Microsoft Excel Crashes
    Replies:
    1
    Views:
    439
    ker_01
    Feb 18, 2010
Loading...

Share This Page