how do I write a formula to select the last entry in a colum

  • Thread starter Thread starter Jme
  • Start date Start date
J

Jme

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

An odd problem with SUM(A:B) and AutoSum 2
Cumulative Values 2
Formula to average last 25 entries in a column? 4
How do I reference a cell as a row number in a formula? 4
Count number of days from the last entry? 2
Q) Referencing the last cell in a formula 1
Average last 4 entries in a row. 8
Showing Last number only 6

Back
Top