Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
update then move down
Hi,
I am not sure how to word this or I would search more on Google for the answers before asking. In my spreadsheet, in Column A I have dollar amounts that I enter daily. A1 is my starting number. I would like a total in column C that stays (moves down) 1 row under the last number entered in Column A. In Column C, the cell would display the difference between the last number entered in Column A and the first number entered in Column A. I guess while I am asking, I would like the Column C number to be blue or red in color depending if the last number in Column A is larger or smaller than the first one. Thanks, Jerry |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
update then move down
Why not put it at the start of the column, no need to worry then.
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Jerry" wrote in message ... Hi, I am not sure how to word this or I would search more on Google for the answers before asking. In my spreadsheet, in Column A I have dollar amounts that I enter daily. A1 is my starting number. I would like a total in column C that stays (moves down) 1 row under the last number entered in Column A. In Column C, the cell would display the difference between the last number entered in Column A and the first number entered in Column A. I guess while I am asking, I would like the Column C number to be blue or red in color depending if the last number in Column A is larger or smaller than the first one. Thanks, Jerry |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
update then move down
If you insert a row to enter you number, the formula in column C should adjust
so in C2 put in =IF(AND(A3="",A2<""),A2-$A$1,"") then format = Cell = Number tab, choose custom [Blue]General;[Red]General;General then select C2 and drag fill down as far as necessary. -- Regards, Tom Ogilvy "Jerry" wrote: Hi, I am not sure how to word this or I would search more on Google for the answers before asking. In my spreadsheet, in Column A I have dollar amounts that I enter daily. A1 is my starting number. I would like a total in column C that stays (moves down) 1 row under the last number entered in Column A. In Column C, the cell would display the difference between the last number entered in Column A and the first number entered in Column A. I guess while I am asking, I would like the Column C number to be blue or red in color depending if the last number in Column A is larger or smaller than the first one. Thanks, Jerry |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
update then move down
"Tom Ogilvy" wrote in message ... If you insert a row to enter you number, the formula in column C should adjust so in C2 put in =IF(AND(A3="",A2<""),A2-$A$1,"") then format = Cell = Number tab, choose custom [Blue]General;[Red]General;General then select C2 and drag fill down as far as necessary. -- Regards, Tom Ogilvy "Jerry" wrote: Hi, I am not sure how to word this or I would search more on Google for the answers before asking. In my spreadsheet, in Column A I have dollar amounts that I enter daily. A1 is my starting number. I would like a total in column C that stays (moves down) 1 row under the last number entered in Column A. In Column C, the cell would display the difference between the last number entered in Column A and the first number entered in Column A. I guess while I am asking, I would like the Column C number to be blue or red in color depending if the last number in Column A is larger or smaller than the first one. Thanks, Jerry Tom, Thanks for your help. I did as you said, but the cell in C is just giving me the last number in A. It is not giving me the difference between the first number in A and the last number in A. Also, I would like to say thanks a million for you and others that help those of us that would never be able to do these things by ourselves. Jerry |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
update then move down
Not sure what to say Jerry. I put the formula in C2 (copied from the email)
then drag filled down column C. put a number in A1, then A2 and C2 showed the difference. Number in A3, C3 showed the difference between A3-A1 and so forth. that was my interpretation of what you wanted and it worked for me. -- Regards, Tom Ogilvy "Jerry" wrote in message ... "Tom Ogilvy" wrote in message ... If you insert a row to enter you number, the formula in column C should adjust so in C2 put in =IF(AND(A3="",A2<""),A2-$A$1,"") then format = Cell = Number tab, choose custom [Blue]General;[Red]General;General then select C2 and drag fill down as far as necessary. -- Regards, Tom Ogilvy "Jerry" wrote: Hi, I am not sure how to word this or I would search more on Google for the answers before asking. In my spreadsheet, in Column A I have dollar amounts that I enter daily. A1 is my starting number. I would like a total in column C that stays (moves down) 1 row under the last number entered in Column A. In Column C, the cell would display the difference between the last number entered in Column A and the first number entered in Column A. I guess while I am asking, I would like the Column C number to be blue or red in color depending if the last number in Column A is larger or smaller than the first one. Thanks, Jerry Tom, Thanks for your help. I did as you said, but the cell in C is just giving me the last number in A. It is not giving me the difference between the first number in A and the last number in A. Also, I would like to say thanks a million for you and others that help those of us that would never be able to do these things by ourselves. Jerry |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
update then move down
"Tom Ogilvy" wrote in message ... Not sure what to say Jerry. I put the formula in C2 (copied from the email) then drag filled down column C. put a number in A1, then A2 and C2 showed the difference. Number in A3, C3 showed the difference between A3-A1 and so forth. that was my interpretation of what you wanted and it worked for me. -- Regards, Tom Ogilvy "Jerry" wrote in message ... "Tom Ogilvy" wrote in message ... If you insert a row to enter you number, the formula in column C should adjust so in C2 put in =IF(AND(A3="",A2<""),A2-$A$1,"") then format = Cell = Number tab, choose custom [Blue]General;[Red]General;General then select C2 and drag fill down as far as necessary. -- Regards, Tom Ogilvy "Jerry" wrote: Hi, I am not sure how to word this or I would search more on Google for the answers before asking. In my spreadsheet, in Column A I have dollar amounts that I enter daily. A1 is my starting number. I would like a total in column C that stays (moves down) 1 row under the last number entered in Column A. In Column C, the cell would display the difference between the last number entered in Column A and the first number entered in Column A. I guess while I am asking, I would like the Column C number to be blue or red in color depending if the last number in Column A is larger or smaller than the first one. Thanks, Jerry Tom, Thanks for your help. I did as you said, but the cell in C is just giving me the last number in A. It is not giving me the difference between the first number in A and the last number in A. Also, I would like to say thanks a million for you and others that help those of us that would never be able to do these things by ourselves. Jerry Tom, After reading your response, I put the formula in a new from scratch spreadsheet and it works perfectly. Something has to be affecting it in the old spreadsheet that I already had the numbers in. So, again thanks very much and I appreciate your response in helping me correct my problem with the code you gave me. Jerry |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel arrows don't move black box but move the window | Excel Discussion (Misc queries) | |||
Automatic update formula when worksheet 1 move to another excel fi | Excel Discussion (Misc queries) | |||
Move - update - sort descending | Excel Discussion (Misc queries) | |||
Template update database, auto move down 1 row | Excel Worksheet Functions | |||
When I move scroll bar in excell the contents do not move with it | Excel Discussion (Misc queries) |