Hello everyone
I don't know if I need a formula or a string of code to complete this task but I will explain what I am trying to accomplish
I have a column array with various cells in that array populated. In every subsequent cell in that array I want a formula that finds the previously populated cell and that value added a cell that is in the same row but two columns to the left.
PLEASE HELP!!!
Thanks
Joey
To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.
If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.
I suspect you can use either / or in this instance (formulae/VBA) but it would be a good idea to outline the setup you have / desired results... it is important that the data types in your sample file reflect reality (ie if numbers use numbers if text use text if mix use a mix)
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Hello everyone
I don't know if I need a formula or a string of code to complete this task but I will explain what I am trying to accomplish
I have a column array with various cells in that array populated. In every subsequent cell in that array I want a formula that finds the previously populated cell and that value added a cell that is in the same row but two columns to the left.
I have attached a mock spreadsheet to illustrate my problem
PLEASE HELP!!!
Thanks
Joey
Joey,
First I would add the following
Then
Please Login or Register to view this content.
Please Login or Register to view this content.
I'm not to sure what you mean, can you add the changes to the sheet and re-post the sheet to the thread?
Last edited by JosephJames; 07-22-2009 at 03:26 PM.
I thought it was quite clear, no ?
Add the text values as indicated into cells E4:G4
Insert the formula provided into E7, copy the formula in E7 and apply it to the entire range of "results" - ie E7:Gx where x is the row determined by the last transaction in your list.
Hi There
I wasn't able to get that formula to work that you provided.
Here is a better description of what I need done as well the excel file is attached to this message
I have Data Validation enabled in column D, depending on what I select in column D, I want a formula/macro enabled that will find the last populated cell in the corresponding column title as what I have chosen with the data validation (ex. Visa would correspond to Visa Column, Visa Credit would correspond to Visa Column). Depending on what the action chosen in Column D is, whether is be credit or debit, I want the last value in the corresponding column to be added to or subtracted from the row I am currently working in.
Ex
On August 15, I have a charge of 200.00 in C63 that will be put on visa (Visa chosen from the drop down in cell D63). I want the formula in cell E63 to automatically find the last visa value (there may be gaps in the data as I have entered chequing or savings transactions and they will be place in the different columns) and add the value of 200.00 to it.
This formula has to be carried down the entire E Column
Hope someone can help!!!
I'm afraid I would disagree, the formula I gave you works based on your question however it will fail given you seemingly need to implement some double entry bookkeeping (not specified in the Q)
eg: Chequing Credit in relation to paying off your Visa bill ...
are you expecting to monitor the narrative also to find the double entry ???
Rather you should be recorded the other side of the transaction as a Visa Credit in an entirely new row.
Last edited by DonkeyOte; 08-18-2009 at 12:25 PM.
The chequing credit when the visa is paid off, is a deduction in the chequing balance as money is coming out of the chequing account. would it be possible for you to implement that formula and upload the spreadsheet so I could see how it was implemented. That would help out immensely
Thanks
Yes, I understand the accounting, my point is your statement is missing the other-side of the transaction... you should have 2 lines for those transactions the first line being that which you have presently (ie the money going out of Chequing Account (Chequing Credit)) the second & currently missing transaction is the Visa Credit line for the same amount on the same day... as is you have a one-sided transaction!
I see what you mean, I have to break it down into two lines as opposed to one that I have currently. Okay I can do that. Does that way I have my sheet now affect the formula, or should I adjust to make the two separate entries then apply that formula that you gave me earlier?
see attached... I am going to remove the earlier attachment in lieu of this.
IT WORKS!!! sorry to put you through that, I am not very good with excel. Thank you very much. How on earth did you come up with that formula?
I don't get out much...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks