Updating cells with "last date used"

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?

example

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

I formatted that ‚Äútable‚ÄĚ as table‚Ķ see This is the guide - How to use the Ask site? - #6 by erAck .

1 Like