Results 1 to 17 of 17

Excel 2007 : Competition scores 1st 2nd =3rd etc

Threaded View

  1. #1
    Registered User
    Join Date
    02-10-2010
    Location
    UK
    MS-Off Ver
    Excel 2007
    Posts
    25

    Competition scores 1st 2nd =3rd etc

    I have a spreadsheet for a competition, where the final scores are in column T, rows 4 to 62. Some of the cells in column T will be blank where a competitor did not finish, and they are penalty scores, so the lowest number wins.

    I am trying to get column U to show 1st, 2nd, 3rd, etc. I also would like the result to show where two competitors have the same score, eg, =3rd, although that is less important.

    I am half-way there, but I can't quite finish it.

    The formula I have got in T4 (and dragged down the rest) so far is:

    =IF(T4="","",RANK(T4,$T$4:$T$62,1))

    This formula is not adding st, nd, rd, th, (1st, 2nd, 3rd, 4th), and neither is it putting = on equal scores.

    Can someone help put the finishing touches to it, please? Or suggest a different formula if there's a better way of doing it? Maybe a macro would be more suitable?

    Many thanks
    Last edited by romperstomper; 07-08-2011 at 05:29 PM. Reason: Mark solved

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