Excel question! Please help.

[RollWave]

I have a bunch of numbers in a couple columns and I want a third column to be the value of the preceding column divided by the column preceding that one.

In other words. I have numbers in column A and B, I want C to be B/A without having to manually enter in each little division problem with an =x/y. How do I do this? I'm so bad at excel.

 

[quakeworld]

double click on a corner of a cell that contains the formula in column c and it should autofill the formula for you.

or you could copy the formula in col C and copy then paste special formula in the remaining cells.

 

[RollWave]

i have no idea how to do what you just said. God I feel old...

 

[It's Not Lupus]

say you have values in A1 and B1. in C1, type: =B1/A1

then copy that cell. select the rest of the cells you want in the column and paste...

 

[Ketchup]

i have no idea how to do what you just said. God I feel old...

Eh, a lot of us are getting up there. See if this helps.

http://blog.contextures.com/archives/2011/08/31/quickly-copy-excel-formula-down/

 

[ignatzatsonic]

say you have values in A1 and B1. in C1, type: =B1/A1

then copy that cell. select the rest of the cells you want in the column and paste...

Or you can just drag the formula in C1 down as far as you need to go by hooking your mouse onto the lower right hand corner of C1. It's a little tricky to grab it just right. The cursor will turn into a simple + when you've got it right--just drag that cross down.