Conditional search and return
My "Start" column has dates for each row; the "Primary" column has ~20 unique values and the sheet has ~80 rows with no parent rows; the "Task" column is mostly unique in each row instance. I am trying to return the minimum "Start" value to an "Order" column based on some keywords in the "Task" column for every unique "Primary" group, and when there are no keywords present for the group, I would like to return an early date, e.g. 1970-01-01.
I have had no luck with combinations of 'IF(),' 'MIN(),' 'MATCH(),' and 'INDEX()' -- I could theoretically do this with an SQL-esque type query, but am unsure how do so or if that is possible.
Help Article Resources
Check out the Formula Handbook template!