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

Recent content by nandhamnk

  1. N

    Formula for summarazing data based on inputs

    It works.Thanks Faseeh :-)
  2. N

    Formula for summarazing data based on inputs

    I cant understand Faseeh.Can you please provide formula in excel sheet please!
  3. N

    Formula for summarazing data based on inputs

    Dear All, I need a summary as below by using formula. Inputs are below: Date Particulars Amount 28-09-2012 ECS/A1 abcdefgh 10000 30/09/2012 ECS/A3 asdefijgk 2000 10-10-2012 ECS/A2 peiourmfk 5000 output as below: ECS Sep-12 Oct-12 Nov-12 Dec-12 A1 10000 (Answer)...
  4. N

    Allocate payment based on FIFO Basis

    Super Narayank991.It works. Thanks Sajan,Chandoo & Narayank991 for the support.
  5. N

    Allocate payment based on FIFO Basis

    Can you please attach excel sheet with formula.
  6. N

    Allocate payment based on FIFO Basis

    Dear Sajan, I cant understand the formula.Instead of creating name ranges can you please put formula for my knowledge .Thanks for the support.
  7. N

    Allocate payment based on FIFO Basis

    Dear All, I need a formula help on allocating payment received from Customer on First cum first basis. For example, Customer Value A 100 B 125 A 110 A 285 A 300 Payment is received for A is 500.It should be allocated as below: Customer Value Payment A 100 100 B 125...
  8. N

    Find Month Using Dates

    Thanks to all.Above formula works.
  9. N

    Find Month Using Dates

    Dear All, I need help on identifying month based on dates. Example, 12/7/2012 - July-12 (Answer) If Date is blank,formula should also blank.
  10. N

    Help on Multiple Vlook-up criteria

    Thanks Muneer.I understand. Thanks for the support.
  11. N

    Help on Multiple Vlook-up criteria

    It working.Thanks for the support.Whats wrong in the previous formula?
  12. N

    Help on Multiple Vlook-up criteria

    I copy pasted as special which is in heading,still it is not working.Can you please check in excel.If it is working for you,can you please upload excel sheet Please!
  13. N

    Formula for Quarter based on Dates

    Yes you are correct Muneer.
  14. N

    Help on Multiple Vlook-up criteria

    Dear Muneer, above vlookup formula is not working for the below case: Currency Apr-11 May-11 Jun-11 Jul-11 USD 44.2150 45.0600 44.7000 44.1900 GBP 73.6025 74.3250 71.5525 71.9650 EUR 65.7425 64.8675 64.7400 63.1450 For EUR,Apr-11 it...
  15. N

    Formula for Quarter based on Dates

    Thanks Suresh.It also works,but the year comes to 2012-13.
See more
Back
Top