0

Sorting item no. - last entry

Hi
I am trying to make a sorted list of item nos. (from item ledger entry).
First the item with the oldest last entry with Entry type consumption.

505113 17-05-2013
505105 27-02-2015
505110 04-03-2015
505108 06-03-2015

I have tried with this (even though I thought I thin it should give me the items with newest entries first) but it does not work.
=NL("rows";"Item Ledger Entry";"item no.";"item no.";"505100..505120";"entry type";"Consumption";"-posting date";"01-01-2013..";)

Any help would be highly appreciated
Br.
mdp12

8 comments

Please sign in to leave a comment.