0

NL Function Reference - What

Sandeep Kuntam

May 08, 2018 17:33

Answered

Follow

I have been using Rows, Last, First in the "what" part of the NL function, 

Is there a way to return the Second record instead of the first or return last but one record?

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Harry Lewis May 08, 2018 17:36

  There sure is, Sandeep.

  Information about all the parameters is in the NL Function Reference.

  For your specific questions:

  second:  =NL(2,...

  last but one:  =NL(-2,...

   

   

• 0
  
  Sandeep Kuntam May 08, 2018 17:40

  Thank you so much Harry