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

Supposing I鈥檓 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 ?|||On the "home" tab, press the "sort %26amp; filter" button on the far right-hand side and press "filter." Then, go to the column with the dates, press the triangle/drop-down and sort such that the most recent items are at the top/bottom.