LAST function


The Klipfolio LAST function returns the last value in a range of data.

The syntax for the LAST function is:

LAST( values , count )





values The value set. number vector
count Optional: The number of values to return from the last value. number scalar

LAST example

Let's look at a LAST function example.



1 one
2 two
3 three

The following example is based on the above text from an Excel spreadsheet:

LAST ( A:A , 2 )

-> ["two","three"]

After applying the LAST function to the column A:A, the text ["one"] is not visible.

Related links: