# need slight edit to current formulas

1. ## need slight edit to current formulas

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

2. ## Re: need slight edit to current formulas

just a slight edit as request:
In AKK2
=IF(COUNTIF(\$A\$2:\$A2,\$A2)>1,"",SUMIF(\$A2:\$A1130,\$A2,\$AKJ2:\$AKJ1130)+ROW()*10^-10)

3. ## Re: need slight edit to current formulas

thanks bebo. that works great.
just one final thing. your edit causes larger numbers to be higher when there is a tie. can you make it so smaller numbers are listed higher.

4. ## Re: need slight edit to current formulas

I am afraid that I could not catch you, can you give examples?

5. ## Re: need slight edit to current formulas

currently if employees 1, 2, and 3 had all the same number of sales, the ranking would be displayed as:
3
2
1

can you make it:
1
2
3

im guessing your edit to formula results in the larger number being ranked higher when there is a tie. i would like the lower number to be ranked higher

6. ## Re: need slight edit to current formulas

By this:
+ROW()*10^-10
I add a very small value to each row
to reverse, change it to:
-ROW()*10^-10

7. ## Re: need slight edit to current formulas

thank you bebo

8. ## Re: need slight edit to current formulas

Nice to hear it works, you are welcome.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1