Problem regarding dynamic range

E

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?
 
E

erikhs

Dave said:
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
Click to expand...

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
 
D

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)
 
Top