Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

RANK Problem

Hello,   When I tried to make RANKX formula, I mostly succeed. But as you see below, some number(nr 19) does not exist in the table in rank column which includes formula. Can you help me ?   Rank...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hello Again ,

 

Is there anybody here who can solve my issue , I will be glad if some of you solve my issue.

  • v-xuding-msft's avatar
    v-xuding-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Anonymous ,

    Please try to change the function of ALL to ALLNOBLANKROW or ALLSELECTED. If it still doesn't work, please share your entire table. You could mask the sensitive data. For the data that you attached, I can't use it to reproduce the result.

     

    Best Regards,

    Xue Ding

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Kudos are nice too.

  • v-xuding-msft's avatar
    v-xuding-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Anonymous ,

    Do you try to change the function? Does it work? If you have solved the issue, please accept the helpful answer. If you solved by yourself, welcome to share the solution. More people who encounter the same problem will benefit here.

     

    Best Regards,

    Xue Ding

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.