Good Day,

I have 3653 rows of data which have the following information by column;

ItemNumber Quantity Date
PRN223 56 02012003
PRN223 44 01042004
PRN223 41 06052003
PRN223 36 11272006
PRN223 49 08221999

What I need to do is first find the last time there was activity on the
item number, the example above would be the 11272006 date as the last
activity,
I then want to purge all the other rows except the one record. I have 562
different item numbers total.