I have a sheet which is used to record food menu items.
Col A contains the date and B the item.
On the RHS side of the sheet I have a list of items used and a column which totals the time they have been used since day 1.
I now want to add a column to show me the last date used of that item.
At the moment I do this by adding the date when I put the entry in col A.
Is there a way to do this automatically?
|date||menu item||menu item||times used||date last used|
|Sat 9 Jul 22||Slow-cooked chicken||Slow-cooked chicken||7||Sat 9 Jul 22|