+ Reply to Thread
Results 1 to 7 of 7

display text after ranking

  1. #1
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2013
    Posts
    4,335

    display text after ranking

    hello

    how todisplay text after ranking numbers..


    Rank text to display
    5 5th placer
    8 8th placer
    2 2nd placer
    4 4th place
    9 9th place
    1 Champion
    3 3rd place




    goes down to 50 rows.
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

  2. #2
    Forum Expert DGagnon's Avatar
    Join Date
    02-23-2012
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2003, 2007
    Posts
    1,645

    Re: display text after ranking

    you could use an if statement somethign like this:

    Please Login or Register  to view this content.
    If you liked my solution, please click on the Star -- to add to my reputation

    If your issue as been resolved, please clearly state so and mark the thread as [SOLVED] using the thread tools just above the first post.

  3. #3
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2013
    Posts
    4,335

    Re: display text after ranking

    thanks.

    If i'll create a table then use vlookup/match does this affect the speed?

    rows will be 50.

  4. #4
    Forum Expert DGagnon's Avatar
    Join Date
    02-23-2012
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2003, 2007
    Posts
    1,645

    Re: display text after ranking

    on 50 rows i dont think you would notice a speed difference, but i think technicaly it would be to do a lookup. you could also use this formula:

    =IF(A1=1,"Champion",A1&INDEX(E$1:E$10,RIGHT(A1,1)+1)&" Place")

    where E1:E10 contains these entries
    th
    st
    nd
    rd
    th
    th
    th
    th
    th
    th

  5. #5
    Forum Expert DGagnon's Avatar
    Join Date
    02-23-2012
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2003, 2007
    Posts
    1,645

    Re: display text after ranking

    Sorry my above would not account for 11,12,13 I did a quick search and came up with this:

    =IF(A1=1,"Champion",A1&MID("thstndrdth",MIN(9,2*RIGHT(A1)*(MOD(A1-11,100)>2)+1),2)&" Place")

  6. #6
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2013
    Posts
    4,335

    Re: display text after ranking

    thats it thanks..

  7. #7
    Registered User
    Join Date
    11-23-2011
    Location
    VietNam
    MS-Off Ver
    Excel 2003
    Posts
    24

    Re: display text after ranking

    Quote Originally Posted by vlady View Post
    thats it thanks..
    Format cells + Conditional Formating
    Attached Files Attached Files

+ 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