Maximum in MS Excel

[geo40]

I think this one is not so difficult, but anyway I cannot manage this issue.

I've two columns

Costplace Pieces
101 12
101 18
201 30
201 25
301 50
301 35
301 26

Now I need a formula which gives me for each costplace the maxima, so I can make following table:

Costplace Maximum
101 18
201 30
301 50

Any help is welcome.

 

[xlbo]

This will work but have a look at this thread for a coupla other options: thread68-374219

=max(sheet1!A1:A100=A2)*(sheet1!B1:B100))
in B2
where your summary columns are on sheet2 A and B, with headers so 101 is in A2, full data is in sheet1, A1:B100

HTH

Rgds
~Geoff~

 

[dsi]

Try using a pivot table. Select the data, do a Data > Pivot Table Report.

Then, drag Costplace to the Row area and Pieces to the Data area. Double click the "Sum of Pieces" and change to Max.