Formula/Method to find who's got top sales (In my example).
Posted by GLITZ on January 06, 2001 3:42 PM
I have 3 columns. Employee Number, Average, Sales
I have 2 awards to determine:top sales and 2nd place sales.
If only one person(employee number)has the top sales amount they are of course top. Same with 2nd.
If more than one employee has the highest number of sales the actual top sales award goes to the one with the highest average and 2nd sales is awarded to the employee with the 2nd highest average.
If top sales is awarded to one person and there is a tie for 2nd sales the employee with the highest average (tied people only) receives the 2nd place award.
Any input on how to create an output for my awards?