ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Easy Reading - large number minus small number (https://www.excelbanter.com/new-users-excel/218805-easy-reading-large-number-minus-small-number.html)

MUTTMIND

Easy Reading - large number minus small number
 
Column A numbers 10 rows down - clear? Column B, a number... smaller than
its A column number: A1 - B1 - clear? Column C says, =A1-B1. Problem, I do
not want to do this step "10 times" - A2-B2, A3-B3. Suggestion - Copy column
A & B into column C and adding the = sign. Me don't know how? You know how?

How would you frame the wording into a searchable subject? Type in your
search words and I get your answer or close to it. In short, what am I
talking about?
I don't know?
Portland, Oregon

Khoshravan

Easy Reading - large number minus small number
 
In C1 after you entered A1-B1 you can copy the formula to other cells in
column C automatically. Put the pointer on C1, Can you see a small square on
bottom left border of C1? Press it and drag as far as you want. This will
copy the formula to rest of the cells.

"MUTTMIND" wrote:

Column A numbers 10 rows down - clear? Column B, a number... smaller than
its A column number: A1 - B1 - clear? Column C says, =A1-B1. Problem, I do
not want to do this step "10 times" - A2-B2, A3-B3. Suggestion - Copy column
A & B into column C and adding the = sign. Me don't know how? You know how?

How would you frame the wording into a searchable subject? Type in your
search words and I get your answer or close to it. In short, what am I
talking about?
I don't know?
Portland, Oregon


Gord Dibben

Easy Reading - large number minus small number
 
Enter =A1-B1 in C1

Double-click on the fill handle of C1

Fill handle is the litlle black lump at bottom right corner of the cell.


Gord Dibben MS Excel MVP

On Mon, 2 Feb 2009 14:09:01 -0800, MUTTMIND
wrote:

Column A numbers 10 rows down - clear? Column B, a number... smaller than
its A column number: A1 - B1 - clear? Column C says, =A1-B1. Problem, I do
not want to do this step "10 times" - A2-B2, A3-B3. Suggestion - Copy column
A & B into column C and adding the = sign. Me don't know how? You know how?

How would you frame the wording into a searchable subject? Type in your
search words and I get your answer or close to it. In short, what am I
talking about?
I don't know?
Portland, Oregon



MUTTMIND

Easy Reading - large number minus small number
 


"Khoshravan" wrote:

In C1 after you entered A1-B1 you can copy the formula to other cells in
column C automatically. Put the pointer on C1, Can you see a small square on
bottom left border of C1? Press it and drag as far as you want. This will
copy the formula to rest of the cells.

"MUTTMIND" wrote:

Column A numbers 10 rows down - clear? Column B, a number... smaller than
its A column number: A1 - B1 - clear? Column C says, =A1-B1. Problem, I do
not want to do this step "10 times" - A2-B2, A3-B3. Suggestion - Copy column
A & B into column C and adding the = sign. Me don't know how? You know how?

How would you frame the wording into a searchable subject? Type in your
search words and I get your answer or close to it. In short, what am I
talking about?
I don't know?
Portland, Oregon


MUTTMIND

Easy Reading - large number minus small number
 
Thank you for your help, I got it. In the easy reading mode, it was not
mentioned what do I do after. The then what?

"Gord Dibben" wrote:

Enter =A1-B1 in C1

Double-click on the fill handle of C1

Fill handle is the litlle black lump at bottom right corner of the cell.


Gord Dibben MS Excel MVP

On Mon, 2 Feb 2009 14:09:01 -0800, MUTTMIND
wrote:

Column A numbers 10 rows down - clear? Column B, a number... smaller than
its A column number: A1 - B1 - clear? Column C says, =A1-B1. Problem, I do
not want to do this step "10 times" - A2-B2, A3-B3. Suggestion - Copy column
A & B into column C and adding the = sign. Me don't know how? You know how?

How would you frame the wording into a searchable subject? Type in your
search words and I get your answer or close to it. In short, what am I
talking about?
I don't know?
Portland, Oregon




MUTTMIND

Easy Reading - large number minus small number
 
Folks... we got a bingo. Yes Yes Yes! One more time yes... it worked thank
you.
You are my best new friend. I thought no way. But, yes way. Thank you
from the muttmind, portland, oregon

"Khoshravan" wrote:

In C1 after you entered A1-B1 you can copy the formula to other cells in
column C automatically. Put the pointer on C1, Can you see a small square on
bottom left border of C1? Press it and drag as far as you want. This will
copy the formula to rest of the cells.

"MUTTMIND" wrote:

Column A numbers 10 rows down - clear? Column B, a number... smaller than
its A column number: A1 - B1 - clear? Column C says, =A1-B1. Problem, I do
not want to do this step "10 times" - A2-B2, A3-B3. Suggestion - Copy column
A & B into column C and adding the = sign. Me don't know how? You know how?

How would you frame the wording into a searchable subject? Type in your
search words and I get your answer or close to it. In short, what am I
talking about?
I don't know?
Portland, Oregon



All times are GMT +1. The time now is 03:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com