Finding the MAX Product sold by Salesperson

[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

 

[Raghavan]

Sort the first table by Column B and you will have in the following format:

 

[Frank Kabel]

Hi
the easies way: use a pivot table.

 

[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.