+ Reply to Thread
Results 1 to 2 of 2

Dynamic named list includes blank cell at bottom

  1. #1
    L Scholes
    Guest

    Dynamic named list includes blank cell at bottom

    I am using the following to create a dynamic list:

    =OFFSET(LookupLists!$A$2,0,0,COUNTA(LookupLists!$A:$A),-1)

    The problem is, it always adds the blank cell at the bottom of the list
    that is also included in the combobox. How do I modify this so it does
    not include the blank cell at the bottom? (I have a header above the
    list in A1 that I do not want included in the list - it is currently
    not included.)

    Thanks in advance.


  2. #2
    L Scholes
    Guest

    Re: Dynamic named list includes blank cell at bottom

    Nevermind, got it!
    =OFFSET(LookupLists!$A$2,0,0,(COUNTA(LookupLists!$A:$A)-1),-1)


+ 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