Hi all,
After receiving unfavourable answers to my enquiry regarding truly blank
cells, I'll get a bit long-winded, and explain what I'm trying to do.
I have a list of text which is created by a formula which has been
filled-down about 100 rows. Currently, only the first 10 cells have text. All
the other cells appear blank, but are really ="" (inserted by an IF statement
in the formula).
As I add data to another part of the sheet, more cells in this list will
become visible text.
I wanted to make a dynamic named range from this list for use in a DV
dropdown.
=OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),1)
But the COUNTA counts all the ="" cells as well as the text, and they appear
in the dropdown as lots of blank rows. Despite the fact that they all appear
at the end of the dropdown, it's still annoying.
I was wondering if I could use COUNTIF instead of COUNTA, to only count text
string lengths of greater than zero, and would that work? I have tried, but
failed thus far.
Any help would be appreciated.
Dave.