Rank function cannot break ties

[f_osolo75]

Can someone tell me why my rank function cannot break ties whenever i use it in excel .

[#2]

@f_osolo75 

See Rank without ties 

[#3]

The reply that I received did not help me . However I received a useful help from the Microsoft Community after posting my issue there . Thanks .