Creating Dynamic Range Using OFFSET and COUNTA Adds Extra Rows

Hello,

I have a table with Column headings in Row 7 and data beginning in Row 8. All table rows are fully populated (no blank cells).

Using the Name Manager tool, I clicked "New" and inserted the following formulas in the formula bar to create Dynamic Ranges in Columns A-C:

=OFFSET(Database!$A$7, 1, 0, COUNTA(Database!$A:$A),1)
=OFFSET(Database!$B$7, 1, 0, COUNTA(Database!$B:$B),1)
=OFFSET(Database!$C$7, 1, 0, COUNTA(Database!$C:$C),1)

After creating the above named ranges, I clicked in the formula bar to verify that the name has properly included all data in the column. What I noticed is that in column A, the formula included 3 blank lines in the range, while in the other two ranges, only 1 blank line was included.

I thought that perhaps there was data appearing in the rows immediately below the table, but that wasn't the case. To be sure, I deleted a few rows, but that did not change the result.

Can anyone provide the reason for this behavior?

Thanks in advance for any replies.

Jeff

Thank you, ChemistB ... I removed the heading at the top of the page and that made all of the ranges equal. Not only that, I amended the formulas to follow the following format:

... COUNTA(Database!$A:$A)-1

and that removed the 1 extra row that was being added to each range.

Much appreciated!