Formula to get last row

Hello:

Please refer to attached file.
I need formula in cell G1 to give the last row in column C.
In this case answer should be 55
Let me know if you have any questions.
Thanks.
Riz

Try this

=LOOKUP(REPT("z",255),C:C,ROW(C:C))

or this

=LOOKUP(2,1/(C:C<>""),ROW(C:C))

Try:

=LOOKUP(2,1/(C1:C100000<>""),ROW(C1:C100000))

Hello:

Thanks to all.

R