As a sequel to this question Formula for matrix (dates in ascending order) how would the formula (=IF($B2="Apple",A2-SORT(FILTER(A:A,B:B="Pear", A:A<$A2),1,FALSE),"")
be modified if the dates are in descending order?
That is, Tony ate an apple on some day, how many days before did he eat a pear?
Best Answer
3 changes, those in red/bold :