select to last row in formula

[Robert H]

In a formula I need to start at a cell and return a reference to the
last row in a column. like using XLdown in VBA.

A:A returns the entire column so I tried A3:A. which does not work.

the application is counting cells from a given point. like so
COUNTA(ListData!A:A) but I just want to start a a given point...

 

[Rishie]

This would not work as the range (i.e. - A3:A) in the formula above
would be considered as Incomplete.

 

[Dave Peterson]

If there are no gaps in the column:
=index(listdata!a:a,counta(listdata!a:a))

or maybe...
=counta(listdata!a1:index(listdata!a:a,counta(listdata!a:a)))

or maybe...
=counta(offset(listdata!a1,0,0,counta(listdata!a:a),1))