I have googled and found many tutorials that are not exactly what I am looking for. I have a spreadsheet that has 3 columns; part number; lot number and expiration date. I have learned how to sort by both part number and date. Part numbers are sorted alphabetically with the shortest shelf life first. What I now need to do is to filter to show only the shortest shelf life for each part number. For some parts there are multiple lot numbers that expire on the same date so I will need those as well. Thanks in advance for any help.
EXAMPLE.xlsx
Bookmarks