• 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. 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)...
  2. 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...
  3. 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.
  4. N

    Formula for Quarter based on Dates

    Dear All, Our accounting period is from April to Mar for every year.I need a formula for Quarter based on the dates. Below is the example: 07/04/2011 Formula should be Q1-FY11-12. Thanks for the help.
  5. N

    Help on Multiple Vlook-up criteria

    Dear ALL, I need to find out sales person based on the below criteria: Below is the database with Customer,Quarter-wise sales person Customer Q1 -FY2011 Q2 -FY2011 Q3 -FY2012 Q4 -FY2012 X Mr.A Mr.A Mr.B Mr.A Y Mr.C Mr.C Mr.C Mr.C Z...
  6. N

    re-arrange the data by Formula

    Dear All, I need a formula help to re-arrange the data Below is the input: A2 B2 1 2 Red 3 4 Green 5 Yellow,Blue,White 6 7 8 Black 9 10 11 Purple 12 Output (Formula in D2) as below: C2 D2 Red 2 Green 4 Yellow 5 Blue 5 White 5 Black 8 Purple 11 Thanks...
  7. N

    Formula for Dates

    Hi all, I required a formula to arrive at exactly correct date before & after the date. Example: Date of birth :07-Aug-1983 Exact date before 12 years before birth (Answer) - 22-Jul-1971 Exact date after 4 years from birth (Answer) - 22-Jul-1987 Request your support please!
  8. N

    Sort data by formula

    Dear All, I need a formula help on the below data: RowA Apple grapes pineapple mango If i say grapes is "1" in B3,then data should be sorted as below: Grapes Pineapple Mango Apple Nee help on this please!
  9. N

    Excel Chart for Consecutive Months.

    Hi, I have a problem of updating chart every month.I usually make a presentation for year (trailing 12 months)and i need to update data each month for chart.Data's are different and i need to present nearly 75 charts. For Example, Chart1 - Revenue - Trailing 12 months Chart2 - Cost-...
Back
Top