I'm trying to set up dynamic ranges (with mixed text/numeric data) using the following base formula:

=OFFSET($A$1,0,0,COUNTA($A:$A),1)

I have a header in the first row, so I want to start my range an A2. When I change the first reference to $A$2; however, the range goes one more row than it needs to. I've also tried to set the row offset to 1 and it still adds the extra row. Does anyone have any suggestions? Thanks!