• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. A

    Break Even Analysis

    Dear Narayan Thanks for the information, Im sorry, I was looking for help on, how I can represent the result (output) in a visually appealing manner, not about how to process it Thanks ..
  2. A

    Break Even Analysis

    Hi their!! Basically I want to come up with a dash board that can visualize the break even .. Here is the question ; We are into fish processing business and the fish purchase price and sales prices are highly volatile and market driven, which we have no control. We always bound to...
  3. A

    Data transfer

    Dear Patnaik Thank you for the code.
  4. A

    Data transfer

    Dear sgmpatnail When I run the macro you have shared with me, I found that data falls out of the range also being copied to the corresponding sheet. The data only within the range from A to F should be copied. How can I alter your macro in this regard. Thanking you,
  5. A

    Data transfer

    Dear sgmpatnail Thank you for your generous effort,, It is definitely going to be useful to me. Thanks once again. Regards / ahamed
  6. A

    Data transfer

    Hi!! Thank you very much for the kind effort and the help, I am going to check now.. Thanks once again... Regards :) RIfkan
  7. A

    Data transfer

    Hi Their !! Here is the sample file for further reference. Thanks
  8. A

    Data transfer

    Hi Everyone I have master sheet (for debtors collection) where I have date, customer name,customer code, invoice no, invoice amount in columns. Beside the master sheet for each customer, a sheet (in the same book) is maintained by the name of customer code. The practice : Every time when a...
  9. A

    Sumproduct too long

    Dear Hui Thank you for the instructions. I may use the entire 10,000 rows, therefore I have no option other than to keep that extent. I suppose sumif wont work when I am to match dates with month {MONTH(A4:A10000)=8} & to convert numeric {--} to get the monthly total. I am not sure how...
  10. A

    Sumproduct too long

    Hi everyone, This is my first thread at chandoo, I am getting a message as sumproduct formula is too long. Please advice how can I over come with an alternative formula for the below; =SUMPRODUCT((--(MONTH(A4:A10000)=Q2)),(--(B4:B10000=P3)),G4:G10000) Thank you in advance :):)
  11. A

    How to consolidate results of different rows to a single cell

    Hi Faseeh Thank you for sharing the post.
  12. A

    How to consolidate results of different rows to a single cell

    I have set of data in rows as follow; Row 1 - 123 Row 2 - 4586 Row 3 - 8921 Row 4 - 125486 Row 5 - D145 How can I construct a formula to bringing all this five rows into a single cell which results an answer as follow; 123,4586,8921,125486,D145 The conventional method is to link 1...
Back
Top