DeniseL0513Copper ContributorSep 03, 2020SolvedFormula 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...Show MorePReaganSep 03, 2020Hello DeniseL0513, That could be:=D28-LOOKUP(2,1/(J:J<>""),J:J)
