| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting a fixed value in to hundereds of cells
I have 3 years worth of daily data in a spreadsheet. To "normalize" the data,
I am requred to add the first cell value to each of the subsequent cells. =sumD4-D4 ---This will yield a zero starting point =sumD5-D4 =SUMD6-D4 =SUMD7-D4 and on and on and on. I need to subrtact D4 from hundreds of lines of data and there has top be a better way than doing each one, line by line. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| FIXED CELLS | Excel Discussion (Misc queries) | |||
| How do I add one fixed amount to several selected cells at once? | Excel Discussion (Misc queries) | |||
| How can I add a fixed value to all cells in a table? | Excel Worksheet Functions | |||
| drawdown at fixed rate over set period from investment at fixed % | New Users to Excel | |||
| Fixed cells? | Excel Discussion (Misc queries) | |||
Threaded Mode
