How to Prepare data

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

Yesterdays's post should show you how to do this

Hi Wizzardofoz,
I don't understand. please explain.

Regards,
sambit

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

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