Search results

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.

Hi, Please check this: =SUMPRODUCT(($A10=Transactions!$C$6:$C$17)*(Transactions!$E$6:$N$17)*(Transactions!$A$6:$A$17>=Budget!C$6)*(Transactions!$A$6:$A$17<=EOMONTH(Budget!C$6,0))) Also see attachment...

Hi Kuriakose, Responding after a long time ..... You need to create named ranges and then use INDIRECT() to fetch data in those lists. See attachment, i hope it is working accurately.

Just a comment, the length of this formula is 6065 characters that can be reduced by adopting shorter sheet name; replacing it from "from BSR v2 Daily" to name like "BSRV2" to get 4049 characters -This is a reduction of 33%. in formula's length.

You can follow these steps: 1. Add a column in between G and H, this will shift Total to right side in column I. 2. Adjust formula in "Totals" to include the empty column: =SUM(B4:H4) Now keep inserting column in between Col G and Col H and Hide column I. The formula in Total column will...

Dear All, Please find attached Chart... Thank you.

Hi, as you said that value of cell A1 is dynamic, did you mean that it will be overwritten in the cell with a newer value? You have also provided an example of values in cell A1 - 5, 3, 5, 2, 1, 6, 7, 9 from where you are getting these values.

Thank you so much Mark!! :)

See this one...

Hi! Can you provide the sample file with dummy data? Thanks

Thank you @ThrottleWorks and @Naresh Yadav :) thanks for the best wishes.

Please use this: =MAX(IF($B$2:$B$10=D3,$A$2:$A$10)) with CSE.

@SirJB7 This is my mistake - we can unprotect worksheets and not workbooks with open office. Sorry for the confusion.

Can you post some sample data?