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!