I have a feeling I'm going to be called a scoundrel again, but here goes. I use named ranges to refer to data that changes in number of rows. I need it for a Data Validation drop down. Deb Dag. had a formula that makes a named range dynamic: =OFFSET(ChoiceCategory!#REF!,0,0,COUNTA(ChoiceCategory!$A:$A),1)
Unfortunately, when all the cells are cleared, I get #REF. How can I not lose it, but also not include blanks or the heading in my DV drop down?
Unfortunately, when all the cells are cleared, I get #REF. How can I not lose it, but also not include blanks or the heading in my DV drop down?