close

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.Nevermind, got it!
=OFFSET(LookupLists!$A$2,0,0,(COUNTA(LookupLists!$ A:$A)-1),-1)

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄