yogi_For Entities In Column A Find The Latest Associated Date In Column B

Google Spreadsheet   Post  #2517

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Sep-27-2018

question by: SteveMO
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/JLgDm3l6HF0;context-place=forum/docs

Stuck on a data analysis problem

I'm somewhere in the middle between a noob and a power user when it comes to google spreadsheet function.  I have experience with array formulas, but have met my waterloo when it comes to this problem.

I have some data that contains a "thing" (in this case a legislative bill) followed by several rows of elements related to that bill.  Among those elements are the dates of most recent actions related to the bill.

I need a formula that finds and evaluates those dates to find the most recent one.

I've tried several angles of attack on this simple problem, and am defeated.

I'd be grateful for any advice or help.

A more detailed explanation would be difficult. Real sample data and more description of the problem are here:

https://docs.google.com/spreadsheets/d/1Oq2udUFZvbFfRp2K6hmfzBUV2KUvzai4cY333nZWoyw/edit?usp=sharing

Thanks in advance!