Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / March 2007

Tip: Looking for answers? Try searching our database.

Finding a count above average

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Don - 30 Mar 2007 20:38 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.