| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Problem in Excel 2003
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 --------------- Jacob Skaria "Andy_jm" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 problem | Setting up and Configuration of Excel | |||
| Excel 2003 formula problem | Excel Discussion (Misc queries) | |||
| Exel 2003 Copy Formula Problem | Excel Worksheet Functions | |||
| Copy and paste problem Excel 2003 to Word 2003 | Excel Discussion (Misc queries) | |||
| Problem copying a formula in Excel 2003 | Excel Discussion (Misc queries) | |||
Hybrid Mode
