Creating new series requires div cell val by itself . How to do t.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
You must log in or register to reply here.

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

divide all cells in a spreadsheet by 1.5 1
HOW DO I CREATE A SERIES INVOLVING CELLS ACROSS ROWS? 3
How to Create a Date Series across a row? 3
Macro to create daily worksheets 6
Need to create a series of dates across a row 4
I'm trying to determine how a series of dropdown lists were creat. 2
Divide By 6
How do I change a number in one cell to change a series of cells? 2

Back
Top