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

Are you trying to pull from sheet 1 or from sheet 2?

Stéphane Charbonneau

I'm trying to pull from sheet 2 the latest date for a specific site, so the latest "Date of visit" from sheet 2 will be pulled in the column "Date of latest visit" in sheet 1

Paul Newcome

Ok. So the Formula on sheet 2 would look something like this:

=MAX(COLLECT({Other Sheet Date Column}, {Other Sheet Site Name Column}, "Site Name"))

Stéphane Charbonneau

This only pulls in the latest date from sheet 2.

I'm trying to pull into the 'Date last visit' on sheet 1 the latest date Hospital 1 was visited from sheet 2

This is sheet 1

Sheet 2

Thanks

Paul Newcome

As long as the site names match, it will pull the latest date for that specific site name. You can replace "Site Name" with either specific text for the site name you are wanting to pull, or since you have a column with that data already in it, you can use a cell reference of [Site Name]@row.