Latest Date from column, if another column contains certain data

Jonathan LeBlanc · 05/28/20

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 · 05/28/20

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 · 05/28/20

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 · 05/29/20

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

Jonathan LeBlanc · 05/29/20

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!

Latest Date from column, if another column contains certain data

Best Answer

Answers

Help Article Resources

Categories