Returns the last row value in a column.

Usage

Last([Column])

Function Arguments:

  • field (required) A column of text, numbers, or dates to analyze.

When there is no sort specified to the table, the results for this function can change when refreshing the workbook, as the sort will be different upon refresh.


Example

Last([Quarter])

Returns the last result in the [Quarter] column in every row of the [Last] column.


See Also


Was this page helpful?
Yes No