Results 1 to 12 of 12

Excel 2007 : rank results to also show text

Threaded View

  1. #1
    Registered User
    Join Date
    12-23-2010
    Location
    Sydney
    MS-Off Ver
    Excel 2007
    Posts
    14

    Unhappy rank results to also show text

    hi all,

    so I am building a racing scoring chart, I need to range a set of cells and bring back the order of placings, but I also need to show the following when they appear
    • "DNF" needs to read as "DNF"
    • "DNS" needs to read as "DNS"
    • when it is blank it will error so I have written an error formula to avoid this, I would like to write something else like an IF that vbrings back "" if it errors

    The current formula I have works for everything but "DNS"
    =IFERROR(IF(J3="DNF",J3,RANK(J3,$J$3:$J$32,1),"")
    If someone could help with this i would be most grateful.

    James
    Last edited by feno1; 02-09-2011 at 04:22 AM. Reason: modified title slightly

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