Excel 2000, count, sort a list & count totals?

[Guest]

Can anyone help me develop a worksheet function, set of functions, or macros
to get this going?

I need to calculate the Total number of times
a Part# is sold, filtered by the number of times it was sold by an
individual.

If the same person sold it more than once,
it is counted only once.

Setup needs to let me enter the the Part#, who sold it; then Excel lists the
Unique Part #, with the total # of sales of it, according to how many people
sold it.

e.g.: Part "1AG" was sold by one person, but part "X53" was sold by three
people: Tom, Sue, and Jim,

Part# Sold by Unique Total sales per
Part # (1 person = 1 sale)
1AG Tom 1AG 1
x53 Tom x53 1
X53 Tom X53 3
X53 Sue CC1 2
CC1 Sue 33Y 1
1AG Tom
x53 Tom
X53 Tom
33Y Jim
CC1 Jim
X53 Jim
1AG Tom
x53 Tom
X53 Tom
X53 Sue
CC1 Sue

Thanks, Bob

 

[Guest]

I would use a pivot table for this kind of analysis.
More info can be found here: http://www.cpearson.com/excel/pivots.htm

Dave