ellyzadg
Board Regular
- Joined
- May 9, 2016
- Messages
- 75
Hi Everyone,
Would like to ask correct formula on how to deal with ranking tie ups. Thank you in advance!
Below are my sample data and desired result
<tbody>
</tbody>
Outcome
<tbody>
</tbody>
Thanks!
Would like to ask correct formula on how to deal with ranking tie ups. Thank you in advance!
Below are my sample data and desired result
Employee ID | Sales Person | Sales | ||||||||||||||||||||||||||||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody>
</tbody>
Outcome
Rank | Sales | Salesperson (what i get) | Desired Result | ||||||||||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody>
</tbody>
Thanks!
Last edited: