Excel 2007 : [SOLVED] Max value

[termsig]

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.

[Marcol]

A sample workbook would go a long way to help solving this problem.

[termsig]

A sample workbook would go a long way to help solving this problem.

I'm really sorry for not posting the sample workbook...

Please see below sample workbook

https://spreadsheets0.google.com/spr...hl=en_GB#gid=1

Many thans.

[Marcol]

Try this in Sheet "summary"
In B2

Please Login or Register  to view this content.

Drag/Fill Down

In C2 this array formula

Please Login or Register  to view this content.

Confirm with Ctrl+Shift+Enter not just Enter
Then Drag/Fill Down.

Hope this helps.