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 )

 

Parameters

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.

 

A

1 one
2 two
3 three

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

FIRST( A:A )

-> ["one"]

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

 

Related links: