Forum Discussion

Copper Contributor

Sep 03, 2020

Solved

Formula Help

I have a list that is updated daily and want to subtract the last value in that list from a constant value. Can anyone help me with a formula? The constant value is in D28 and the ongoing list is...

excel

Formulas and Functions

PReagan
Sep 03, 2020
Hello DeniseL0513,

That could be:
=D28-LOOKUP(2,1/(J:J<>""),J:J)

PReagan

Bronze Contributor

Sep 03, 2020

Hello DeniseL0513,

That could be:

=D28-LOOKUP(2,1/(J:J<>""),J:J)

DeniseL0513

Copper Contributor

Sep 03, 2020

PReagan Thank you!!! That worked!!!

PReagan
Bronze Contributor
Sep 03, 2020
DeniseL0513

Happy to help!