Dynamic named ranges in Excel
Expand down as many rows as there are numeric and text entries. In the refers to box type:
=OFFSET($A$1,0,0,COUNTA($A:$A),1)
Expand down as many rows as there are numeric and text entries. In the refers to box type:
=OFFSET($A$1,0,0,COUNTA($A:$A),1)