Excel Avanced

Hi Jinyan

Thanks for your question

If you go to insert-Name and then define. Click new and give the range a meaningful name. In the refers to box type

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

Here the named range starts at Range A2 and then nests the countA function within the offset function. This counts down from A1 to the last cell in the column that contains a value

I enclose an example worksheet

Hope this helps

Regards

Stephen