Results 1 to 5 of 5

Thread: How to Prepare data

  1. #1
    Conjurer sambit's Avatar
    Join Date
    Sep 2014
    Posts
    143
    Articles
    0
    Excel Version
    Excel2007

    Post How to Prepare data



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Sir,
    we have two place of sale i.e, japan and Italy. how to Prepare date wise price comparision statement where japan price is > (greter than) Italy Price.

    Condition : Material Type, Material Code, Grade, Thickness, Width and Finish are same.

    please find attached sale data cum report.xlsx where you get two sheet, one is sale data and another sheet is report.

    my question is how to get data like report sheet ?

    what formula to apply for getting report ?

    please help.

    Regards,
    sambit
    Attached Files Attached Files

  2. #2
    Conjurer WizzardOfOz's Avatar
    Join Date
    Sep 2013
    Location
    Australia
    Posts
    184
    Articles
    0
    Excel Version
    Office 365
    Yesterdays's post should show you how to do this

  3. #3
    Conjurer sambit's Avatar
    Join Date
    Sep 2014
    Posts
    143
    Articles
    0
    Excel Version
    Excel2007
    Hi Wizzardofoz,
    I don't understand. please explain.

    Regards,
    sambit

  4. #4
    Conjurer WizzardOfOz's Avatar
    Join Date
    Sep 2013
    Location
    Australia
    Posts
    184
    Articles
    0
    Excel Version
    Office 365
    Sorry was a bit hasty in my reply. I read it as a simple multicriteria question.
    This is possibly best to do with a pivot table rather than with a complex formula.

    If you create a pivot table with Filters on Material Type, Material Code, Grade, Thickness, Width and Finish
    Rows on Invoice date, Invoice no, Price
    Columns on Place of sale
    and sum(Quantity) as Values
    Then query the result to display in your report should be a lot easier

    Will see if I can do more later

  5. #5
    Excel 2010 PivotTable
    Items can be pivoted, filtered or sorted oodles of ways.
    Comparisons might require PowerPivot.
    http://www.mediafire.com/view/pevcha...09_19_14a.xlsx

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •