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.

Share This Page