How to pull latest date from a second sheet for a specific item

Stéphane Charbonneau

I'm trying to pull the latest date a certain site has been visited include that in summary sheet from second containing visits data. In secon sheet, specific can have multiple lines corresponding different vists. Any help with formulas do this would be greatly appreciated. Consider it your COVID-19 effort :).

Sheet one columns: Site name; Date of latest visit; etc.

A site has only one row in sheet 1

Sheet 2 columns: Site name; Date of visit; etc.

A site can have multiple rows in sheet 2

Paul Newcome

Is THIS THREAD the same question? If so, I have responded there. If not, I will be happy to help here as well. Just let me know.