Subtracting Two Tables
 

Is it possible to easily subtract two tables and place the results into
another table? I have two 4x4 tables. The left corners are at A1 and F1.
I would like the result to appear in the corner at A7.
--
Wayne Watson (Watson Adventures, Prop., Nevada City, CA)

(121.015 Deg. W, 39.262 Deg. N) GMT-8 hr std. time)
Obz Site: 39° 15' 7" N, 121° 2' 32" W, 2700 feet

Solid waste produced to generate electricity per person
over a lifetime:
Nuclear power -- 2 pounds in a coke can
Fossil (coal) fuel -- 68.5 tons in six 12-ton RR cars

-- Power to Save the World, Gwyneth Cravens

Web Page: <www.speckledwithstars.net/

Subtracting Two Tables
 

In A7 enter =A1-F1 or =F1-A1.

Copy across to D7 then down to A10:D10.

--
Biff
Microsoft Excel MVP


wrote in message
...
Is it possible to easily subtract two tables and place the results into
another table? I have two 4x4 tables. The left corners are at A1 and F1. I
would like the result to appear in the corner at A7.
--
Wayne Watson (Watson Adventures, Prop., Nevada City, CA)

(121.015 Deg. W, 39.262 Deg. N) GMT-8 hr std. time)
Obz Site: 39° 15' 7" N, 121° 2' 32" W, 2700 feet

Solid waste produced to generate electricity per person
over a lifetime:
Nuclear power -- 2 pounds in a coke can
Fossil (coal) fuel -- 68.5 tons in six 12-ton RR cars

-- Power to Save the World, Gwyneth Cravens

Web Page: <www.speckledwithstars.net/

Subtracting Two Tables
 

T. Valko wrote:
In A7 enter =A1-F1 or =F1-A1.

Copy across to D7 then down to A10:D10.

I don't seem to be able copy down from d7. I'm guessing when I settle on
a7, after entering =f1-a1, that the little cross in the lower right-hand
corner is some mechanism for copying. All works well for row a7 to to d7.

--
Wayne Watson (Watson Adventures, Prop., Nevada City, CA)

(121.015 Deg. W, 39.262 Deg. N) GMT-8 hr std. time)
Obz Site: 39° 15' 7" N, 121° 2' 32" W, 2700 feet

Solid waste produced to generate electricity per person
over a lifetime:
Nuclear power -- 2 pounds in a coke can
Fossil (coal) fuel -- 68.5 tons in six 12-ton RR cars

-- Power to Save the World, Gwyneth Cravens

Web Page: <www.speckledwithstars.net/

Subtracting Two Tables
 

Subtracting Two Tables
 

the little cross in the lower right-hand corner
is some mechanism for copying.

Yes, it's called the fill handle, that small black square in the lower-right
corner of the selection. When you hover your mouse over it the cursor
changes to a "skinny plus sign".

--
Biff
Microsoft Excel MVP


wrote in message
...
wrote:
T. Valko wrote:
In A7 enter =A1-F1 or =F1-A1.

Copy across to D7 then down to A10:D10.

I don't seem to be able copy down from d7. I'm guessing when I settle on
a7, after entering =f1-a1, that the little cross in the lower right-hand
corner is some mechanism for copying. All works well for row a7 to to d7.

Ah, I had to copy down each column from the first row, 7. Thanks.

--
Wayne Watson (Watson Adventures, Prop., Nevada City, CA)

(121.015 Deg. W, 39.262 Deg. N) GMT-8 hr std. time)
Obz Site: 39° 15' 7" N, 121° 2' 32" W, 2700 feet

Solid waste produced to generate electricity per person
over a lifetime:
Nuclear power -- 2 pounds in a coke can
Fossil (coal) fuel -- 68.5 tons in six 12-ton RR cars

-- Power to Save the World, Gwyneth Cravens

Web Page: <www.speckledwithstars.net/