If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|