Formula Help

[DeniseL0513]

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 in J4:J33

[#2]

Hi @DeniseL0513,

=d28-j33

[#3 · Accepted solution]

Hello @DeniseL0513,

That could be:

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

[#4]

@PReagan Thank you!!! That worked!!!

[#5]

@DeniseL0513 

Happy to help!