Thread: how do I write a formula to select the last entry in a colum
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default how do I write a formula to select the last entry in a colum
try

=IF(LOOKUP(10^23,D:D)<M206,M206-LOOKUP(10^23,D:D),LOOKUP(10^23,D:D)-M206)

Mike

"Jme" wrote:

I am trying to track a cumlative sum that gets a new value added each day so
I want the formula =IF(D185<M206,M206-D185,D185-M206) to change the D185 to
the last non-blank value in column D
Reply With QuoteReply With Quote