Good morning,

I have a two column list of Dates(A) and items used (B). Example is below. I want to look down the list of items and return the most recent date it was used.

The second twist is that the list of items can contain multiple items in each cell. I can change the table to get around this but would be ideal if I could leave it as is. The list is currently sorted Date, Oldest date first.



10/2 Hammer
10/3 Hammer, Screwdriver
10/4 Screwdriver
10/5 Wrench, Hammer.


I would like to have a master list of items and be able to see the most recent date used.

Hammer 10/5
Screwdriver 10/4
Wrench 10/5

Any suggestions?

Thank you for your help.

Todd