top of page
Jet Reports

How to Use NL ("First") Function to Display the First Value in a Table

NL ("First") is a powerful Jet function that returns the first result found, only the first result. It can be used to extract the first value from any table. In this tutorial, we will use NL ("First") to show the first customer number in Excel.

Join On Point Academy to view all content

Procedure

  1. Open your Excel report and navigate to the Jet tab.


  2. Click on the "Tools" button and select the NL function from the drop-down menu.



3. In the pop-up window, fill in the following details:


  • "First" in the "What" tab.

  • "Customer" in the "Table" tab.

  • "No" in the "Field" tab.






4. Click on "OK".


5. Give the column a name in cell D4.


6. Run the report to see the first customer number.



NL ("First") is a great tool for quickly retrieving the first value in a table. By following this tutorial, you should now be able to use the NL ("First") function to display the first customer number in Excel.

Get trained
the On Point way

​

From self paced online courses to private training sessions.
Become industry ready.
bottom of page