The Nth function repeats the Nth value of the the given column for every row in a column.


Usage

Nth([Column], n)

Function Arguments:

  • [Column] (required) - A column of text, numbers, or dates to analyze.
  • n (required) - Offset from top of column. Must be a constant integer greater than 0.  

When there is no sort specified to the table, the results for this function can change if you refresh the workbook. The sort is different upon refresh.


Example

Nth([Quarter], 2)

Returns the 2nd result in the [Quarter] column for every row in the [Nth] column.


See Also


Was this page helpful?
Yes No