Rankif with tie breaker

Hi guys,

I want to be able to rank different IDs for a certain name based on $$$. For example, if person A has several IDs, I want to be able to tell the top 5 IDs based on $$$. Also, there are two problems. One is, there are several duplicate IDs and I want to rank "None" for those which already have rank. Second, there are different IDs with the same $$$, I want to be able to tie break those. Problem 1 is ok if you cannot solve, but I will need to solve problem 2. Attached is the excel file.

Thanks in advance!

Any help guys? Need it urgently. Thanks.

Hi sktneer,

This is not what I want to achieve. This does not separate A&B.