Lookup - LastRow

Syntax:
=LastRow(Column, Optional Worksheet, Optional Workbook)

Description:
Returns the last row that contains a value for a particular column.

Example:
Find the last row for column 5 that contains a value.
=LastRow(5)