Forum Discussion
cjp1993
Jun 29, 2022Copper Contributor
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...
Lorenzo
Jun 29, 2022Silver Contributor
If not 2021 or 365:
in Q2 as a regular formula (Enter only):
=IF(LOOKUP(2,1/(B2:O2<>0),B2:O2) <> P2, LOOKUP(2,1/(B2:O2<>0),B2:O2), P2)