Forum Discussion
Debbie_Wood
Oct 09, 2023Copper Contributor
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...
peiyezhu
Oct 10, 2023Bronze Contributor
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;