Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to hide blank cells in a range | Excel Discussion (Misc queries) | |||
Display first, second, etc Nonblank Cells in a Range | Excel Worksheet Functions | |||
Counting empty cells within a range of cells | New Users to Excel | |||
Counting empty cells within a range of cells | New Users to Excel | |||
Count cells in one range based on parameters in another range | Excel Worksheet Functions |