Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
subtract column E to column D in every row
does anyone know how to subract two columns for each row?
D E F 1 3 4 1 2 2 3 instead of me subracting column D from E for every row, is there a formula I can use to get the diffence to enter in column F? I have about 1000 rows to do, and it's just taking so long. thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
subtract column E to column D in every row
In cell F1 enter the formula:
=E1 - D1 Then select the cell again and double-click the "fill handle" - the small black square in the bottom right corner. This will copy the formula down automatically for as many rows as you have data in column E. Hope this helps. Pete |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
subtract column E to column D in every row
In F1 type =D1-E1. That will give you the answer in F1.
Now select F1 and select Copy from the Edit menu. Now highlight all those cells in column F that you are interested in (select F2 and then hold down shift key and click in the last cell you want in column F) then select Paste from the Edit menu Best of luck Philip "junkgrrl" wrote in message ... does anyone know how to subract two columns for each row? D E F 1 3 4 1 2 2 3 instead of me subracting column D from E for every row, is there a formula I can use to get the diffence to enter in column F? I have about 1000 rows to do, and it's just taking so long. thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
subtract column E to column D in every row
Another way
....select your cells in column F that you want your formula in, next type your formula in the active cell hold down the Ctrl key and hit enter. HTH Jean-Guy "Philip Reece-Heal" wrote: In F1 type =D1-E1. That will give you the answer in F1. Now select F1 and select Copy from the Edit menu. Now highlight all those cells in column F that you are interested in (select F2 and then hold down shift key and click in the last cell you want in column F) then select Paste from the Edit menu Best of luck Philip "junkgrrl" wrote in message ... does anyone know how to subract two columns for each row? D E F 1 3 4 1 2 2 3 instead of me subracting column D from E for every row, is there a formula I can use to get the diffence to enter in column F? I have about 1000 rows to do, and it's just taking so long. thanks |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
subtract column E to column D in every row
i tried doing it, and it didn't subract the other rows...just gave me this on
F1 =F2:F908=E1-D1 "pinmaster" wrote: Another way ...select your cells in column F that you want your formula in, next type your formula in the active cell hold down the Ctrl key and hit enter. HTH Jean-Guy "Philip Reece-Heal" wrote: In F1 type =D1-E1. That will give you the answer in F1. Now select F1 and select Copy from the Edit menu. Now highlight all those cells in column F that you are interested in (select F2 and then hold down shift key and click in the last cell you want in column F) then select Paste from the Edit menu Best of luck Philip "junkgrrl" wrote in message ... does anyone know how to subract two columns for each row? D E F 1 3 4 1 2 2 3 instead of me subracting column D from E for every row, is there a formula I can use to get the diffence to enter in column F? I have about 1000 rows to do, and it's just taking so long. thanks |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
subtract column E to column D in every row
You should have highlighted F1 to F908, then typed
=E1 - D1 then held down CTRL while pressing ENTER to this method to work. However, there were two other methods you were given above, so hopefully one of those has been sucessful for you. Pete |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
match and count words | Excel Worksheet Functions | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
How do I subtract 20% from one column in Excel and place totals i. | Excel Discussion (Misc queries) |