Enhancement to RANK function when dealing with tied rankings

It would be really useful for certain cases if the RANK function could generate a sequential output when dealing with tied data.  

 

Currently, the RANK function can deal with tied entries in 4 ways, MAXIMUM, MINIMUM, AVERAGE and SEQUENTIAL and all handle tied data in a slightly different way but do not generate an output in which items are ranked as 1,2,3,4,5 in an incremental way.  The output skips rankings when using MAXIMUM, MINIMUM and AVERAGE and ignores tied rankings when using SEQUENTIAL.

 

This is a bit difficult to explain in words so please see the attached image showing the outputs currently generated by RANK and the desired output which it would be good to add as an enhancement to the RANK function.

 

If any members of this community fancy a challenge and can show an alternative neat and performant way of generating this output then I'd love to hear it!

1 Comment
Community Manager
 
Status changed to: Needs Community Support
Users Online
Currently online: 253 members 754 guests
Please welcome our newest community members: