Thanks Thanks:  0
Likes Likes:  0
Page 2 of 3 FirstFirst 123 LastLast
Results 11 to 20 of 27

Thread: Ranking Issue

  1. #11
    Board Regular
    Join Date
    Jul 2017
    Location
    Sherbrooke, Canada
    Posts
    289
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Ranking Issue

    Hum, you had 2 times the rank 12 (Sales 328 and sales 340). I evaluated both formula and observed a difference in the rank part of the formula. One showed 10 and the other showed 9. Both cells equal 115%. I rewrote the second one and instantly, the problem was solved ...

    I clearly don't understand the problematic here and will try to find the origin of this problem. If someone else know the reason in the forum, I hope they will help you.

  2. #12
    New Member
    Join Date
    Nov 2016
    Location
    egypt
    Posts
    41
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Ranking Issue

    Quote Originally Posted by Roxxien View Post
    Hum, you had 2 times the rank 12 (Sales 328 and sales 340). I evaluated both formula and observed a difference in the rank part of the formula. One showed 10 and the other showed 9. Both cells equal 115%. I rewrote the second one and instantly, the problem was solved ...

    I clearly don't understand the problematic here and will try to find the origin of this problem. If someone else know the reason in the forum, I hope they will help you.
    thanks for your support
    also i hope anyone solve it

  3. #13
    . MrExcel's Avatar
    Join Date
    Feb 2002
    Location
    Merritt Island Florida
    Posts
    855
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Ranking Issue

    There is something evil with your cell F344.
    It is showing 115%. But it contains something slightly larger than 115%.
    I can't figure out what is in there, but if I sort the percentages descending, Store 340 comes before Store 27, 118, and 328 which also contain 115%.

    I figure it was a floating point issue, but there is no way that I can coax 115.00000001 out of that cell.

    So, I can't tell you what is causing it. But I can tell you a simple fix: Go to cell F344. Type 115%. The formulas that you have will start working again.
    View a collection of recent Excel articles in the Excel Daily News

  4. #14
    New Member
    Join Date
    Nov 2016
    Location
    egypt
    Posts
    41
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Ranking Issue

    Quote Originally Posted by MrExcel View Post
    There is something evil with your cell F344.
    It is showing 115%. But it contains something slightly larger than 115%.
    I can't figure out what is in there, but if I sort the percentages descending, Store 340 comes before Store 27, 118, and 328 which also contain 115%.

    I figure it was a floating point issue, but there is no way that I can coax 115.00000001 out of that cell.

    So, I can't tell you what is causing it. But I can tell you a simple fix: Go to cell F344. Type 115%. The formulas that you have will start working again.
    thanks MR.excel
    this part of automated report all numbers generated automatically
    I can't type number myself in any cell.

  5. #15
    New Member
    Join Date
    Nov 2016
    Location
    egypt
    Posts
    41
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Ranking Issue

    can anyone help me please

  6. #16
    Board Regular
    Join Date
    Apr 2017
    Location
    Suhum, Ghana, West Africa
    Posts
    669
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Ranking Issue

    Okay then what if you round the number? Maybe you round all up or down.

    Like =roundup(A1,0) or rounddown(A1,0)
    Based on what you wanna achieve so that you can do away with all floating points.
    Regards
    Kelly

  7. #17
    New Member
    Join Date
    Nov 2016
    Location
    egypt
    Posts
    41
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Ranking Issue

    Quote Originally Posted by kelly mort View Post
    Okay then what if you round the number? Maybe you round all up or down.

    Like =roundup(A1,0) or rounddown(A1,0)
    Based on what you wanna achieve so that you can do away with all floating points.
    Regards
    Kelly
    Round help in this case but numbers will not be accurate

    is that any other formula to rank uniquely

  8. #18
    Board Regular
    Join Date
    Apr 2017
    Location
    Suhum, Ghana, West Africa
    Posts
    669
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Ranking Issue

    How uniquely?

  9. #19
    New Member
    Join Date
    Nov 2016
    Location
    egypt
    Posts
    41
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Ranking Issue

    Quote Originally Posted by kelly mort View Post
    How uniquely?
    if i use =rank(number,ref) it will duplicate ranks , you will see two or three numbers in same rank

  10. #20
    Board Regular
    Join Date
    Apr 2017
    Location
    Suhum, Ghana, West Africa
    Posts
    669
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Ranking Issue

    Post a small sample of how you want your output look like.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com