I am trying to rank the clients based on fees. As I've shown in below table, in
column A I have the country and
column B the client name. So I want to find the Ranking in
column D based on fee has been charged in
column C. I have over 20K clients and I have tried to do it in Pivot table but it does not make a clear ranking for me because of the two criteria listing.
Which combination of formulas would solve this problem?
A B C D 1 Country N-Client Fees Rank 2 Belgium A Company $720 3 Canada A Company $210 4 Belgium B Company $1300 5 Canada A Company $500 6 Canada C Company $600