+ Reply to Thread
Results 1 to 16 of 16

Data Validation and Dynamic Named Ranges

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    06-17-2010
    Location
    Philadelphia, PA
    MS-Off Ver
    Excel 2010
    Posts
    228

    Re: Complex Data Validation

    NBVC, would it matter that the JanuaryOneContacts list is defined as:

    =OFFSET('Background Info'!$F$5,0,0,COUNTIF('Background Info'!$F$5:$F$25,">"""),1)

    The way that formula is built shouldn't really matter - I just wanted to include that to show its not a simple defined list.

    Also, when I type in "January One" in B2 and then use tha that formula I get the error "The source currently evaluates to an error. Would you like to continue?" The drop down is then blank.
    Last edited by freybe06; 07-19-2011 at 05:04 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1