Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Formula Problem in Excel 2003
0 views
Skip to first unread message
Andy_jm
Nov 25, 2009, 7:50:01 AM11/25/09
to
I have a spreadsheet with a column of data to which I add figures twice a
day. In another column I have a formula to calculate the daily average. What
I'm trying to do is to have another cell which automatically updates whith
the difference between the first and last daily averages.
day. In another column I have a formula to calculate the daily average. What
I'm trying to do is to have another cell which automatically updates whith
the difference between the first and last daily averages.
Jacob Skaria
Nov 25, 2009, 7:58:01 AM11/25/09
to
If you have the daily averages in Col C and the first daily average in cell
C2 then try the below formula
C2 then try the below formula
=C2-LOOKUP(10^10,C:C)
OR
=ABS(C2-LOOKUP(10^10,C:C))
If this post helps click Yes
---------------
Jacob Skaria
0 new messages