Finding the MAX Product sold by Salesperson

C

carlos

I have a table like so:

A B C
SalesPerson Product Sales
JIM BOX1 100
ERIC BOX2 500
JIM BOX2 300
ERIC BOX1 200

I would like to create a second table that looks like so:

JIM BOX2
ERIC BOX2

Thanks in advance
 
C

carl

thank you frank. do you know where i place the salesperson
and product in the pivot table. how do i get the table to
show me just the product that the salesperson sold the
most of ?

i tried a website cited in an earlier thread but could not
find an example that was simlar to mine.

regards.
 
Top