Thread: how do I write a formula to select the last entry in a colum
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jme Jme is offline
external usenet poster
  
Posts: 1
Default how do I write a formula to select the last entry in a colum
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