| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Creating new series requires div cell val by itself . How to do t.
I am trying to rebase a time series which requires dividing the first value
in each series by itself. I keep getting circular error messages regardless of how I format the calculation. Is ther a way around this issue? |
|
#2
|
|||
|
|||
|
Texas
When you divide a number(and time is a number) by itself you will get 1. Is that what you want? You could use a couple of helper columns. Assume data in column A. In B1 enter =A1. In C1 enter =A1/B1. Gord Dibben Excel MVP On Mon, 21 Mar 2005 12:35:08 -0800, "Texastom" wrote: I am trying to rebase a time series which requires dividing the first value in each series by itself. I keep getting circular error messages regardless of how I format the calculation. Is ther a way around this issue? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic series in Chart | Charts and Charting in Excel | |||
| How do I make a cell equal to another cells value and not it's fo. | Excel Worksheet Functions | |||
| fill a particular cell on a series of worksheets from a lookup tab | Excel Discussion (Misc queries) | |||
| Creating a series of data | Excel Worksheet Functions | |||
| Excel: how to formulate conditional cell references | Excel Worksheet Functions | |||
Linear Mode
