Hi, Ken:

Thanks for the answer. This means if I have the following example on
Sheet1:

ColumnA
Row1
Row2
Row3 5
Row4 6
Row5 7
Row6 10
Row7
Row8


Then the formula should be the following if I want to include 5,6, and
7 in my range (I DO NOT want to include the last number 10 in my
range):

=OFFSET(Sheet1!$A$3,0,0,COUNTA(Sheet1!$A:$A)-1,1)

Am I doing correct based on your post?

Thanks,

Jorge