Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula question
Is there any way to insert a formula that will automatically divide each cell
in a particular column against its corresponding cell in other column? I have over 800 divisions per statistic and up to a dozen statistics on one sheet, and would like to avoid typing in =h5/d5, s12/d12, etc. in every cell if possible. It could take me months to enter all those values. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula question
Maybe I worded that a bit incorrectly.
I want a cell, say the h column, from one row, say row 14, to be divided against another cell in the same row, all the way down the page. Sorry, I'm new at this. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula question
You should just be able to drag down the column and excel will auto format
for you. example; if the values to divide are in a1 and b1 and you want the division in c1. In c1 type in =a1/b1 and hit enter. Then just click on c1 and you should see a little cross in the lower corner of the c1, click and hold on the cross and drag it down the column. Good luck "Brayden" wrote: Is there any way to insert a formula that will automatically divide each cell in a particular column against its corresponding cell in other column? I have over 800 divisions per statistic and up to a dozen statistics on one sheet, and would like to avoid typing in =h5/d5, s12/d12, etc. in every cell if possible. It could take me months to enter all those values. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula question
Unreal! I searched in the help and couldn't find that.
Thank you sooo much you have saved me from wasting many hours! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What IF - formula question | Excel Worksheet Functions | |||
what IF - formula question | Excel Worksheet Functions | |||
What IF - formula question | Excel Worksheet Functions | |||
Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
Formula Question | Excel Worksheet Functions |