Hello,
I started a thread a while back asking how to rank employees based on the amount of sales they have made (http://www.excelforum.com/excel-form...formances.html).
Fotis1991, who is a genius by the way, seemed to have the answer. however, now im actually using the formula, ive realised that its not working perfectly.
ive found that when two employees have the same total number of sales, the ranking lists just one of the employees twice. i was hoping it would list both and perhaps rank them by alphabetical/numerical order.
so for example, in the attached workbook if you change cell AKJ3 on Our Raw Data to 20, you will see on sheet 3 that employee 1 is listed twice with no mention of employee 2.
thanks if you can help
Bookmarks