Hello all
I have two drop downs with the second dependent on the first. These work fine. My issue is the second drop down is populated by data on another sheet which includes blank formula cells. I have placed this formula in the named range -
=OFFSET(Classes!$A$2,0,0,SUMPRODUCT(--(LEN(ClassesList[Art])>0)),1)
This formula works perfectly in terms of selecting the populated cells and ignoring the blank formula cells. My issue is that it is not taking the list over to the drop down. So I click on the first drop down and the second is not being populated with the list generated by the dynamic range.
Any help would be most appreciated.
Regards
I have two drop downs with the second dependent on the first. These work fine. My issue is the second drop down is populated by data on another sheet which includes blank formula cells. I have placed this formula in the named range -
=OFFSET(Classes!$A$2,0,0,SUMPRODUCT(--(LEN(ClassesList[Art])>0)),1)
This formula works perfectly in terms of selecting the populated cells and ignoring the blank formula cells. My issue is that it is not taking the list over to the drop down. So I click on the first drop down and the second is not being populated with the list generated by the dynamic range.
Any help would be most appreciated.
Regards
