D
dhstein
I have a dynamic drop down list. I define a name "VendorList" with this
formula:
=OFFSET(Inventory!$KB$2,0,0,COUNTA(Inventory!$KB:$KB),1)
In my dropdown location - I use =VendorList and it works.
The problem is that there are cell in column KB that evaluate to "" and I
don't want these in the dropdown. These are at the end of the column. So I
tried to define VendorList like this:
=OFFSET(Inventory!$KB$2,0,0,SUMPRODUCT(--(KB2:KB200<>"")),1)
But this doesn't work. I get no items in the dropdown.
Is it that I can't use SUMPRODUCT in this way? Is there another solution?
Thanks for any help on this.
formula:
=OFFSET(Inventory!$KB$2,0,0,COUNTA(Inventory!$KB:$KB),1)
In my dropdown location - I use =VendorList and it works.
The problem is that there are cell in column KB that evaluate to "" and I
don't want these in the dropdown. These are at the end of the column. So I
tried to define VendorList like this:
=OFFSET(Inventory!$KB$2,0,0,SUMPRODUCT(--(KB2:KB200<>"")),1)
But this doesn't work. I get no items in the dropdown.
Is it that I can't use SUMPRODUCT in this way? Is there another solution?
Thanks for any help on this.