Hi Dilip,

I have the basic Score under Column O and ranking has been done on this score which is reflected
under Column P. Now Column P has multiple ranks and you will see under column there is a tie for Rank No 15.

Now I need to break the ties based on the values reflected Under column Q & R. Note column Q & Column R will have data
only if there is a tie in Column P. Since column P has a tie for Rank 15, I need to break this tie based on data reflected under Q & R and I want
the final ranking in Column U.

Hope this helps. BTW I tries your formula , doesnt seem to help.
Thanks

Mysore