Excel - Group Rows together Sequentially

In Excel, I am working with a dataset of around 2000 rows.

The rows can have multiples of the same account but different charges. (For example, Account 3745 shows up 3 times with charges $1000, $500, and $250)

I want to have a column that will sequentially label the account with numbers 1-3; 1 being the account with the largest charge, 2 being the next largest, and 3 being the lowest.(Example: 1 - $1000, 2 - $500, - 3 - $250)

Then the next grouping of accounts will have it's own sequential numbering 1-x number, doing the same thing as above.

Is there a formula for this or do I have to get fancy somehow?

Thanks!

Try COUNTIFS:

=COUNTIFS($A$2:$A$10,A2,$B$2:$B$10,">"&B2)+1