Difference between 2 cells (growing column)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Stumped??? - 31 Jul 2008 18:34 GMT

I have a column of numbers, that grows one cell per day. I need to find the
difference between the previous day's cell and today's cell. The formula I
use is =SUM((LARGE(A5:A235,1))-(LARGE(A5:A235,2))), which works fine as long
as the current day's cell is greater than the previous day's; however when
the current day's cell is smaller, the number tends to be inaccurate. Is
there an IF function or other formula that can be used in the column that
would would look only at the last cell with data and the previous to it,
ignoring the rest and then would change as data is entered into the blank
cell infront of it?

Thanks!

Reply to this Message

MyVeryOwnSelf - 31 Jul 2008 19:05 GMT

> I have a column of numbers, that grows one cell per day. I need to
> find the difference between the previous day's cell and today's cell.
[quoted text clipped - 3 lines]
> then would change as data is entered into the blank cell infront of
> it?

One way is to use something like:
=OFFSET($A$1,COUNT($A:$A)-1,0)-OFFSET($A$1,COUNT($A:$A)-2,0)
This assumes there are no gaps in the column.

Reply to this Message