FIRST function

The Klipfolio FIRST function returns the first value in a range of data.

The syntax for the FIRST function is:

FIRST( values , count )


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

FIRST example

Let's look at a FIRST function example.



1 one
2 two
3 three

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


-> ["one"]

In this example, after using the FIRST function only the first value, ["one"], is returned. 

Related links: