pivot table question

C

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
Click to expand...
where to place ?

Thank you in advance.
 
Top