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...
Debbie_Wood If you a Microsoft365 user then could try below dynamic array formula-
=LET(
i,SCAN(A2,A2:A16,LAMBDA(a,x,IF(x="",a,x))),
MAP(A2:A16,LAMBDA(t,IF(t="","",TAKE(SORT(FILTER(B2:B16,i=t),1,-1),1)))))See the attached file.