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...
=IF(A2<>"",MAX(INDEX($B$2:$B$26,ROW(B2)-1):INDEX($B$2:$B$26,IFERROR(SMALL(IF(A2:$A$26<>"",ROW(A2:$A$26)-1),2)-1,COUNT($B$2:$B$26)))),"")
You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel for the web or Excel 2021.