Forum Discussion
Formula to look at varying number of cells and return latest date.
I have a large spreadsheet that lists order numbers in column A and the date that each parcel within that order was dock confirmed in column B. I need to create a formula to look at the dates in col...
create temp table aa as
select *,fillna(`Order`) ord from last_date;
create temp table bb as
select ord,max(`Date`) latest_date from aa group by ord;
create temp table cc as
select * from aa left join bb on aa.`Order`=bb.ord;
select colExclude[\bord\b] from cc;