SOLVED

Formula Help

%3CLINGO-SUB%20id%3D%22lingo-sub-1632766%22%20slang%3D%22en-US%22%3EFormula%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1632766%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20list%20that%20is%20updated%20daily%20and%20want%20to%20subtract%20the%20last%20value%20in%20that%20list%20from%20a%20constant%20value.%20%26nbsp%3BCan%20anyone%20help%20me%20with%20a%20formula%3F%20%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20constant%20value%20is%20in%20D28%20and%20the%20ongoing%20list%20is%20in%20J4%3AJ33%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1632766%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1632874%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1632874%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F781360%22%20target%3D%22_blank%22%3E%40DeniseL0513%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%3Dd28-j33%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1632907%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1632907%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F781360%22%20target%3D%22_blank%22%3E%40DeniseL0513%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThat%20could%20be%3A%3C%2FP%3E%3CPRE%3E%3DD28-LOOKUP(2%2C1%2F(J%3AJ%26lt%3B%26gt%3B%22%22)%2CJ%3AJ)%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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

4 Replies
Highlighted

Hi @DeniseL0513,

=d28-j33

 

 

Highlighted
Best Response confirmed by DeniseL0513 (New Contributor)
Solution

Hello @DeniseL0513,

 

That could be:

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

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

Highlighted

@DeniseL0513 

 

Happy to help!