Finding a count above average

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting Unique occurences of text in a column 12
A counting problem 1
count col-A if col-B = condition 8
Code Check Request - Query to find reused values 2
Pivot Table - Count wNo Duplicates 1
Pivt or grouping or some other means to summarize data 2
Calculate sales in the week by day ? 6
Desperate Help needed with a function. 3

Top