Recent content by Faseeh

Thank you. see attachment.

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...

Hi, Please see if solution in SuggestedSol is acceptable. Thanks

Thank you so much, Mark! This is really helpful.

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 =...

This is working like a magic!! I am still trying to understand how it is done. :) Please explain it a little!

For now around 700 for each of the sheet but as it holds work orders, the number of rows will increase.

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.

Hi, Please see this post by chandoo: https://chandoo.org/wp/working-hours-formula/

There is no harm in trying with dummy data but it will be really time consuming.

Hi, Please check link, it is showing an error.

Hi, Please see this post of chandoo: https://chandoo.org/wp/indian-currency-format-excel/

There is an extra space in cells C3 and C5:C12, removing that space will remove that duplicate... See attachment.