Excel 2007 : [SOLVED] Max value

Hello,

I'm trying do some formula in excel but nothing is working for me.
Will be very appreciate for any advice.

I'm having to tabs with information, one is called data and another summary.

Data table is looking like

Product Location Country Qty
123 Manchester UK 3
123 London UK 4
123 Liverpol UK 6
123 Oxford UK 1

Summary tab include all products and it should also include the city with the biggest qty

Thanks.