Problem regarding dynamic range

[erikhs]

Hi,

One quick question:

I have tried to create a dynamic range using the standard formula:
=OFFSET($A$1,0,0,COUNT($A:$A),1)

However i get an error stating something is wrong in the formula. I
know this is very little information, but do you have any idea what
could be wrong?

 

[Dave Peterson]

Your formula worked ok for me.

Do you use commas as your list separator--or maybe the semicolon???

And did you really want Count or CountA?

I use Debra Dalgeish's site when I need this kind of range name:
http://contextures.com/xlNames01.html#Dynamic

 

[Don Guillett]

try countA

 

[erikhs]

Your formula worked ok for me.

Do you use commas as your list separator--or maybe the semicolon???

And did you really want Count or CountA?

Dave Peterson

Hi Dave and Don,

I think the problem might very well be that i use semicolon instead o
comma. I will try it tomorrow.
Thank you for your help

 

[bobocat]

Hi, How can I use dynamic range with some blank cell in the range?

 

[Don Guillett]

where you are looking for a larger than possible number or letter.
=OFFSET(Sheet1!$A$1,0,0,MAX(MATCH(99999,Sheet1!$A:$A),MATCH("zzzz",Sheet1!$A:$A)),1)