Forum Discussion
Stuck trying to find a formula for most recent change in a series of numbers
Hi all, Trying to figure out a formula that I can apply to a large dataset where I have a a set of columns representing months, and the rows representing rent amounts for properties. I nee...
=INDEX(B2:G2,,LARGE(IF((B2:G2>0)*(B2:G2<>H2),COLUMN(B:G)),1)-1)If you don't work with Office365 or 2021 you can try this formula. Enter the formula with ctrl+shift+enter.