I have a data list on one worksheet. The list includes: sales rep id,
customer number, customer name, and a number of unique items sold to each
account. On the second sheet I have a list of my sales reps and their sales
rep id.
What I'd like to do is calculate the number of accounts for each individual
sales rep that have total unique items above the median number for that
particular sales rep. I cannot figure out how to do this.
Any help would be appreciated.
Don Rountree

Signature
Don Rountree
Domenic - 30 Mar 2007 22:47 GMT
Can you post a small sample of the data, along with the expected results?
> I have a data list on one worksheet. The list includes: sales rep id,
> customer number, customer name, and a number of unique items sold to each
[quoted text clipped - 7 lines]
> Any help would be appreciated.
> Don Rountree