C
caldog
I have looked at the rank function, but I do not think that it is the
function for what I need.
I have a list of salesmen, four in total, that sell three different types of
merchandise.
How would I rank number one through four, based on how they sold each of the
six different types of merchandise.
Example:
Salesman 1,6,18,4
Salesman 2,11,0,3
Salesman 3,2,5,20
Salesman 4,1,3,2
To complicate matters each set of merchandise categories is sorted
individually by amount sold.
Merchandise #1
Salesman 2 11
Salesman 1 6
Salesman 3 2
Salesman 4 1
Merchandise #2
Salesman 1 18
Salesman 3 5
Salesman 4 3
Salesman 2 0
Merchandise #3
Salesman 3 20
Salesman 1 4
Salesman 2 3
Salesman 4 2
Total Sales and Ranking
Salesman 1 28
Salesmen 3 27
Salesmen 2 14
Salesmen 4 6
So what I am looking for is a formula that will put the combined total by
the right salesman, and when I sort by using Data-Sort, each salesman keeps
its correct total.
Steve
function for what I need.
I have a list of salesmen, four in total, that sell three different types of
merchandise.
How would I rank number one through four, based on how they sold each of the
six different types of merchandise.
Example:
Salesman 1,6,18,4
Salesman 2,11,0,3
Salesman 3,2,5,20
Salesman 4,1,3,2
To complicate matters each set of merchandise categories is sorted
individually by amount sold.
Merchandise #1
Salesman 2 11
Salesman 1 6
Salesman 3 2
Salesman 4 1
Merchandise #2
Salesman 1 18
Salesman 3 5
Salesman 4 3
Salesman 2 0
Merchandise #3
Salesman 3 20
Salesman 1 4
Salesman 2 3
Salesman 4 2
Total Sales and Ranking
Salesman 1 28
Salesmen 3 27
Salesmen 2 14
Salesmen 4 6
So what I am looking for is a formula that will put the combined total by
the right salesman, and when I sort by using Data-Sort, each salesman keeps
its correct total.
Steve