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.
Bookmarks