Try something like this...

=OFFSET($A$2,0,0,MATCH(2,1/($A$2:$A$65536<"")))

Note that you cannot use a whole column reference for the MATCH function
in this case.

Hope this helps!

In article ,
"z.entropic" wrote:

Attempting to autorange the chart, I've tried to use Ozgrid's solutions with
named ranges, e.g.:
===============
Expand Down to The Last Numeric Entry
In the Refers to box type: =OFFSET($A$1,0,0,MATCH(1E+306,$A:$A,1),1)

4:Expand Down to The Last Text Entry
In the Refers to box type: =OFFSET($A$1,0,0,MATCH("*",$A:$A,-1),1)
================

Somehow, these formulas choke up with my mix of numbers, text strings and
blanks. Unfortunately, the column can have either as the last item. COUNT,
COUNTA and COUNTBLANK didn't help to resolve the issue. Is there a better
way to count the number of rows with such a mix of entries?

z.entropic