+ Reply to Thread
Results 1 to 7 of 7

Ranking table

  1. #1
    Registered User
    Join Date
    12-14-2009
    Location
    ireland
    MS-Off Ver
    Excel 2003
    Posts
    11

    Ranking table

    Hi, I have a problem with a table i am working with.
    Its ranks people based on percetnages and inserts them into a table on the table. First worked no problem but when you insert it into other sheets whcih needs to be done every week its is displayed like

    Call Logging - Rankings
    1 Craig Faulkner 100%
    2 Fiona Watson 100%
    3 Gavin Baird 99%
    4 Otto 98%
    5 Ruairi Taylor 98%
    6 #N/A #N/A
    7 #N/A #N/A
    8 Malachy Kelly 95%
    9 #N/A #N/A

    It is because the tavle it is referncing is sometime blank or because the percentages are the same. Is theres a way of doing it so that it includes a side table for hang ups or possibly by inserting in alphabetical order?
    Attached Files Attached Files

  2. #2
    Forum Expert darkyam's Avatar
    Join Date
    03-05-2008
    Location
    Houston, TX
    MS-Off Ver
    2013
    Posts
    2,191

    Re: Ranking table

    See this link. See particularly the section about Unique Ranks in Descending Order.

  3. #3
    Registered User
    Join Date
    12-14-2009
    Location
    ireland
    MS-Off Ver
    Excel 2003
    Posts
    11

    Re: Ranking table

    tired using the uniqe descending order but it still comes up as like

    Otto 98%
    5 Ruairi Taylor 98%
    6 #N/A #N/A
    7 #N/A #N/A
    8 Malachy Kelly 95%
    9 #N/A #N/A

  4. #4
    Forum Expert darkyam's Avatar
    Join Date
    03-05-2008
    Location
    Houston, TX
    MS-Off Ver
    2013
    Posts
    2,191

    Re: Ranking table

    Perhaps I'm missing something, but when I open up the workbook, I see no #N/A errors.

  5. #5
    Registered User
    Join Date
    12-14-2009
    Location
    ireland
    MS-Off Ver
    Excel 2003
    Posts
    11

    Re: Ranking table

    sorry made mistake there. that was the first sheet that works fine. i've attached the sheet that i am having a problem with now. it should make the problkem alot more clearer.
    Attached Files Attached Files

  6. #6
    Forum Expert darkyam's Avatar
    Join Date
    03-05-2008
    Location
    Houston, TX
    MS-Off Ver
    2013
    Posts
    2,191

    Re: Ranking table

    Try =IF(O5<>"",RANK(O5,$O$5:$O$40)+COUNTIF($O$4:O4,O5),"") instead. This gets rid of both ties and #N/A errors.

  7. #7
    Registered User
    Join Date
    12-14-2009
    Location
    ireland
    MS-Off Ver
    Excel 2003
    Posts
    11

    Thumbs up Re: Ranking table

    cheers thats works great, thanks for that

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1