Latest Date from column, if another column contains certain data

Jonathan LeBlanc

I have 2 columns: first column is a multi-select with multiple, the second column are all dates.

I want to pull the latest date by each of the items available in the multi-select

I figure its some combination of If, Large, and contains. but I'm at a loss on how to nest them together

thanks

Chris Mondeau

Hi Jonathan,

Maybe this is what you're looking for?

I'm using the collect function to collect the array of dates for any row that contains the "multi" value, then returning the maximum/largest date from that set. (in the example I've highlighted the range for "dog" values).

Here's the rest of the max dates:

Chris Mondeau

Hi Jonathan,

Maybe this is what you're looking for?

I'm using the collect function to collect the array of dates for any row that contains the "multi" value, then returning the maximum/largest date from that set. (in the example I've highlighted the range for "dog" values).

Here's the rest of the max dates:

Paul Newcome

I would use the same. MAX/COLLECT with a CONTAINS for the criteria.

Jonathan LeBlanc

cmondo, this looks good, I didn't know that the collect function existed, so now it makes sense.

Thought I replied to this yesterday, so thanks again!