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

Stéphane Charbonneau · 04/24/20

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 · 04/24/20

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

Stéphane Charbonneau · 04/24/20

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 · 04/24/20

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 · 04/24/20

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 · 04/27/20

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.

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

Answers

Help Article Resources

Categories