0

nl last not returning the last date

Hello - I am having a bit of trouble with the nl last function. I am looking to return the last creation date of payroll batch. I built two functions that are exactly the same except the first is a "rows" and the second is a "last".

the first function is an nl rows function that a returns a list of payroll batch creation dates:
=NL("Rows","G/L Register","Creation Date","Journal Batch Name","PAYROLL*","Company=", B3)
The results of this function are:
9/30/2013
10/5/2013
10/7/2013
10/8/2013

The second function is the exact same except it uses "last", it is:
=NL("Last","G/L Register","Creation Date","Journal Batch Name","PAYROLL*","Company=", B3)
The results of this function are:
9/30/2013

I'm wondering why isn't this returning the last creation date (10/8/2013)?

8 comments

Please sign in to leave a comment.