+ Reply to Thread
Results 1 to 8 of 8

formula for ranking

  1. #1
    Forum Contributor max_max's Avatar
    Join Date
    06-28-2013
    Location
    italy - venice
    MS-Off Ver
    Excel 2007
    Posts
    1,693

    formula for ranking

    Hello to all,
    I seek your help ... and I try to explain that my inglesa is understandable.
    I have two columns: A and B
    in column A there are names (A1 Frank - Max A2 - A3 Julian)
    in column B next to the names there are numbers
    Name - score
    Frank - 10
    Max - 20
    Jilian - 30

    the winner is momentary Jilian, you can make it appear in another cell "Jiulian is first"
    If there were more winners to reveal their names.
    I attach the file
    Thanks for your help.
    max_max

    ---------------------------------------------------------------------------------------------------

    Ciao a tutti,
    cerco il vostro aiuto...cerco di spiegare e che il mio inglesa sia capibile.
    Ho due colonne : A e B
    nella colonna A ci sono dei nomi ( A1 Frank - A2 Max - A3 Julian)
    nella colonna B a fianco ai nomi ci sono dei numeri
    Nome - punteggio
    Frank - 10
    Max - 20
    Jilian - 30

    il vincitore momentaneo è Jilian, è possibile fare apparire in un altra cella "Jiulian è primo"
    Se ci fossero più vincitori fare apparire i nomi.
    Allego il file
    Grazie dell'aiuto.
    max_max

    max_max.xlsx
    Last edited by max_max; 08-23-2013 at 07:12 AM.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,733

    Re: help formula

    See attached file.

    Hope this helps.

    Pete
    Attached Files Attached Files

  3. #3
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: help formula

    @ max_max

    Pls take some minutes to read forum rules, because:

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

    Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

    To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    Also let us know if there is a possibility 2 persons to have the same number. In this case suggested by Pete formula will not work.
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  4. #4
    Valued Forum Contributor
    Join Date
    09-15-2011
    Location
    Chennai, India
    MS-Off Ver
    Excel 2010
    Posts
    436

    Re: help formula

    Im sorry. I know only English. Im not able to understand the language you have mentioned. (I assume that you have translated the same query)

    Please try this file.
    Attached Files Attached Files
    Last edited by ramananhrm; 08-23-2013 at 06:35 AM.
    Please click 'Add reputation', if my answer helped you.

  5. #5
    Forum Contributor max_max's Avatar
    Join Date
    06-28-2013
    Location
    italy - venice
    MS-Off Ver
    Excel 2007
    Posts
    1,693

    Re: help formula

    Thanks Pete,
    there is an error: if there are 2 names with equal scores writes only the first name.
    max_max

    --------------------------------------------------------------------------------------

    Grazie Pete,
    c'è un errore: se ci sono 2 nomi con punteggio uguale scrive solo il primo nome.
    max_max

  6. #6
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,733

    Re: help formula

    Okay, amended file attached, with tie-breaks.

    Hope this helps.

    Pete
    Attached Files Attached Files

  7. #7
    Forum Contributor max_max's Avatar
    Join Date
    06-28-2013
    Location
    italy - venice
    MS-Off Ver
    Excel 2007
    Posts
    1,693

    Re: formula for ranking

    Hello Pete if I have not responded,
    the file works.
    Thank you,
    max_max

  8. #8
    Forum Contributor
    Join Date
    07-02-2013
    Location
    Stockholm, Sweden
    MS-Off Ver
    Excel 2003 and 2007
    Posts
    197

    Re: formula for ranking

    I think this formula for the ranking order is more correct:
    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)

Similar Threads

  1. Ranking formula?
    By kufta4 in forum Excel General
    Replies: 5
    Last Post: 10-19-2011, 01:08 PM
  2. Replies: 6
    Last Post: 06-01-2010, 06:19 PM
  3. Ranking Formula
    By fmac in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-01-2009, 10:22 AM
  4. Ranking Formula
    By alizok in forum Excel General
    Replies: 9
    Last Post: 06-23-2009, 03:17 PM
  5. Ranking formula
    By mohitmahajan in forum Excel General
    Replies: 11
    Last Post: 02-18-2005, 01:05 AM

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