How to substruct in a range of cells?
 

I have a table with 3 columns and several hundred rows. In column A entered
years (1920, 1910, 1930, etc). In column B entered age of a person
(32,76,43, etc). In column C I'd like to enter the year of birth of these
persons which, of course, is the result of subtracting the age from the
year. Using formula for the first row =A1-B1 gives the correct answer. But
I'd like to enter data in all cells in column C at once. Whatever I do, I'm
getting the error.
May someone please guide me through this process? What formula should I use?
I'll appreciate your help.

--
Ilya Zeldes
Fort Myers, Florida

How to substruct in a range of cells?
 

Please disregard this request. I solved my problem.
Ilya

"ilyaz" wrote in message
...
I have a table with 3 columns and several hundred rows. In column A entered
years (1920, 1910, 1930, etc). In column B entered age of a person
(32,76,43, etc). In column C I'd like to enter the year of birth of these
persons which, of course, is the result of subtracting the age from the
year. Using formula for the first row =A1-B1 gives the correct answer. But
I'd like to enter data in all cells in column C at once. Whatever I do, I'm
getting the error.
May someone please guide me through this process? What formula should I
use?
I'll appreciate your help.

--
Ilya Zeldes
Fort Myers, Florida

How to substruct in a range of cells?
 

Select the cell w/your formula A1-B1. Put the cursor over the black box, it
should change to a black cross. Click left mouse button and drag down as far
as needed, then let up on the mouse button.

"ilyaz" wrote:

I have a table with 3 columns and several hundred rows. In column A entered
years (1920, 1910, 1930, etc). In column B entered age of a person
(32,76,43, etc). In column C I'd like to enter the year of birth of these
persons which, of course, is the result of subtracting the age from the
year. Using formula for the first row =A1-B1 gives the correct answer. But
I'd like to enter data in all cells in column C at once. Whatever I do, I'm
getting the error.
May someone please guide me through this process? What formula should I use?
I'll appreciate your help.

--
Ilya Zeldes
Fort Myers, Florida

How to substruct in a range of cells?
 

Thanks, JMB. Appreciate your advice!
Ilya

"JMB" wrote in message
...
Select the cell w/your formula A1-B1. Put the cursor over the black box,
it
should change to a black cross. Click left mouse button and drag down as
far
as needed, then let up on the mouse button.

"ilyaz" wrote:

I have a table with 3 columns and several hundred rows. In column A
entered
years (1920, 1910, 1930, etc). In column B entered age of a person
(32,76,43, etc). In column C I'd like to enter the year of birth of these
persons which, of course, is the result of subtracting the age from the
year. Using formula for the first row =A1-B1 gives the correct answer.
But
I'd like to enter data in all cells in column C at once. Whatever I do,
I'm
getting the error.
May someone please guide me through this process? What formula should I
use?
I'll appreciate your help.

--
Ilya Zeldes
Fort Myers, Florida

How to substruct in a range of cells?
 

Easier yet...........double-click on the black cross.

No dragging involved.


Gord Dibben MS Excel MVP

On Fri, 18 Aug 2006 02:32:22 -0400, "ilyaz" wrote:

Thanks, JMB. Appreciate your advice!
Ilya

"JMB" wrote in message
...
Select the cell w/your formula A1-B1. Put the cursor over the black box,
it
should change to a black cross. Click left mouse button and drag down as
far
as needed, then let up on the mouse button.

"ilyaz" wrote:

I have a table with 3 columns and several hundred rows. In column A
entered
years (1920, 1910, 1930, etc). In column B entered age of a person
(32,76,43, etc). In column C I'd like to enter the year of birth of these
persons which, of course, is the result of subtracting the age from the
year. Using formula for the first row =A1-B1 gives the correct answer.
But
I'd like to enter data in all cells in column C at once. Whatever I do,
I'm
getting the error.
May someone please guide me through this process? What formula should I
use?
I'll appreciate your help.

--
Ilya Zeldes
Fort Myers, Florida

How to substruct in a range of cells?
 

Thanks, Gord! But I got your advice to late for this job. Will use it next
time!
Ilya

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Easier yet...........double-click on the black cross.

No dragging involved.


Gord Dibben MS Excel MVP

On Fri, 18 Aug 2006 02:32:22 -0400, "ilyaz" wrote:

Thanks, JMB. Appreciate your advice!
Ilya

"JMB" wrote in message
...
Select the cell w/your formula A1-B1. Put the cursor over the black
box,
it
should change to a black cross. Click left mouse button and drag down
as
far
as needed, then let up on the mouse button.

"ilyaz" wrote:

I have a table with 3 columns and several hundred rows. In column A
entered
years (1920, 1910, 1930, etc). In column B entered age of a person
(32,76,43, etc). In column C I'd like to enter the year of birth of
these
persons which, of course, is the result of subtracting the age from the
year. Using formula for the first row =A1-B1 gives the correct answer.
But
I'd like to enter data in all cells in column C at once. Whatever I do,
I'm
getting the error.
May someone please guide me through this process? What formula should I
use?
I'll appreciate your help.

--
Ilya Zeldes
Fort Myers, Florida

How to substruct in a range of cells?
 

One more arrow for your quiver.

Gord

On Tue, 22 Aug 2006 20:13:00 -0400, "ilyaz" wrote:

Thanks, Gord! But I got your advice to late for this job. Will use it next
time!
Ilya

"Gord Dibben" <gorddibbATshawDOTca wrote in message
.. .
Easier yet...........double-click on the black cross.

No dragging involved.


Gord Dibben MS Excel MVP

On Fri, 18 Aug 2006 02:32:22 -0400, "ilyaz" wrote:

Thanks, JMB. Appreciate your advice!
Ilya

"JMB" wrote in message
...
Select the cell w/your formula A1-B1. Put the cursor over the black
box,
it
should change to a black cross. Click left mouse button and drag down
as
far
as needed, then let up on the mouse button.

"ilyaz" wrote:

I have a table with 3 columns and several hundred rows. In column A
entered
years (1920, 1910, 1930, etc). In column B entered age of a person
(32,76,43, etc). In column C I'd like to enter the year of birth of
these
persons which, of course, is the result of subtracting the age from the
year. Using formula for the first row =A1-B1 gives the correct answer.
But
I'd like to enter data in all cells in column C at once. Whatever I do,
I'm
getting the error.
May someone please guide me through this process? What formula should I
use?
I'll appreciate your help.

--
Ilya Zeldes
Fort Myers, Florida







Gord Dibben MS Excel MVP