Formula Problem in Excel 2003

  • Thread starter Thread starter Andy_jm
  • Start date Start date
A

Andy_jm

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.
 
If you have the daily averages in Col C and the first daily average in cell
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
 

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

Help with Formula in Excel 2003 1
Automatic Formula Update 2
EXCEL FORMULA 0
Excel Average dates help 0
averaging from different sheets and folders 1
Convert average daily yield to APY 4
Copying formulas across columns 2
Average function 5

Back
Top