In your given example, the stock Option Grand Date start month does not reflect on month time line for example if i set it to April 25, the month of Feb and March should display zero. Is this correct? So as per my understanding, amortization amount should start from a start_month, should see if...
Thank you so much for this explanation. What if I want to add more columns to right? Which part i need to adjust to accommodate more columns? I think that the following constant needed to be updated for more columns:
Const C = "A1:A#&""¤""&B1:B#&""¤""&C1:C#&""¤""&D1:D#", M =...
Hi,
Thank you so much for going through the post!
I am struggling with the automation of the following task. I have googled a lot but the existing macros either fulfil part of the total requirement or are not working for me (somehow).
I have two sheets: 1. Source 2. Ledger. I am trying to...
I believe you will have to do so by Defining a Name - and there you will create a formula that will yield the cumulative figure for each month. When you will be asked to plot a series, you will be using that Name.
I believe the best way is to use a secondary table. May be you can put that in some other sheet to avoid clutter, but the effort that you will put in to get this from one shot formula may be too much.