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

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how do I write a formula to select the last entry in a colum (https://www.excelbanter.com/excel-discussion-misc-queries/190974-how-do-i-write-formula-select-last-entry-colum.html)

Jme

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

Mike H

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

All times are GMT +1. The time now is 06:02 AM.