Returns the first row value of a column.

Usage

First([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

First([Quarter])
  • Returns the first result in the [Quarter] column in every row of the [First] column.


See Also


Was this page helpful?
Yes No