pivot table question

[carlos]

I have a table like so:

A B C
Product Units
BOX1 22
BOX2 4
BOX1 100
BOX2 500

I would like to have a formula in C3:C6 that will look at
A1:A3 and return True for the MAX Value

I would like to create a 2nd table that shows me the MAX
Units per Product

Product Max Units
BOX1 100
BOX2 500

Using the Pivot Table Wizard. Could someone guide me on

where to place ?

Thank you in advance.