I visit 4 theatres regularly, sometimes multiple theatres on the same day but never the same theatre on the same day. I have columns A, B and C in the picture attached.
Column A records the date a theatre is visited
Column B records which theatre is visited on that date
Column C is a complete list of all theatres visited
I'd like column D to auto populate with the most recent date the theatre in column C was visited
Bonus would be to have column E show days since last visit but I think I can figure that out on my own.
Any help would be greatly appreciated!