How to retrieve the last transactions of all items within a spread sheet which are of different dates ?

Supposing I’m using an excel spread sheet for a stock ledger that records the receiving and issuance as well as the balance of a series of stock items within the same spreadsheet. The transaction of each of these stocks items will be transacted at different times and at different dates. Is there anyway that I can retrieve the last transaction (which are likely to be from different dates) of all items within a single spread sheet report ?