Rank function cannot break ties

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3168887%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3ERank%20function%20cannot%20break%20ties%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3168887%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3ECan%20someone%20tell%20me%20why%20my%20rank%20function%20cannot%20break%20ties%20whenever%20i%20use%20it%20in%20excel%20.%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3168887%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EExcel%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3168887%22%20slang%3D%22en-US%22%3ERank%20function%20cannot%20break%20ties%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3168887%22%20slang%3D%22en-US%22%3E%3CP%3ECan%20someone%20tell%20me%20why%20my%20rank%20function%20cannot%20break%20ties%20whenever%20i%20use%20it%20in%20excel%20.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3168887%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

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

2 Replies
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 .