Quote Originally Posted by Glenn Kennedy View Post
Yep. Totally clear, now.

=(LOOKUP(2,1/(IF(ISNUMBER(SEARCH("total",$C8:$C132)),0,1)*D8:D132>0),D8:D132)-D8)/D8

copied across. Neurons 1, ChatGPT 0... I think.

Thank you for your effort. Unfortunately you have come across the same issue as me I think. Your formula finds D34 (Total 23) and believes that that is the most recent data where as actually it should be ignoring that row