+ Reply to Thread
Results 1 to 3 of 3

giving points by a result (function)

  1. #1
    Perttu O.
    Guest

    giving points by a result (function)

    is there a way to give points by a function ?

    and in english, sport results (points) in excel sheet, let's say varying
    from 10 to 100 and I would like to give them points from 10 down. meaning
    that the best player (biggest points) would get 10 points, next biggest
    points would get 9 and so on.

    is there a formula or function to make this automatically ?



  2. #2
    David Billigmeier
    Guest

    RE: giving points by a result (function)

    Have a look at VLOOKUP() in the help menu.

    --
    Regards,
    Dave


    "Perttu O." wrote:

    > is there a way to give points by a function ?
    >
    > and in english, sport results (points) in excel sheet, let's say varying
    > from 10 to 100 and I would like to give them points from 10 down. meaning
    > that the best player (biggest points) would get 10 points, next biggest
    > points would get 9 and so on.
    >
    > is there a formula or function to make this automatically ?
    >
    >
    >


  3. #3
    Perttu O.
    Guest

    Re: giving points by a result (function)


    I am little bit lost...

    i know how to find largest, 2nd large etc, but how to make function that
    looks up how largest players result is and looks up from the other chart to
    give points

    any help ?

    player A B C D
    results 19 10 48 5
    points ? ? ? ?

    --

    result points
    #1 5
    #2 3
    #3 2
    #4 1


    "David Billigmeier" <DavidBilligmeier@discussions.microsoft.com> wrote in
    message news:92D82D83-A503-45AC-B6FE-E80A7863BF49@microsoft.com...
    > Have a look at VLOOKUP() in the help menu.
    >
    > --
    > Regards,
    > Dave
    >
    >
    > "Perttu O." wrote:
    >
    >> is there a way to give points by a function ?
    >>
    >> and in english, sport results (points) in excel sheet, let's say varying
    >> from 10 to 100 and I would like to give them points from 10 down. meaning
    >> that the best player (biggest points) would get 10 points, next biggest
    >> points would get 9 and so on.
    >>
    >> is there a formula or function to make this automatically ?
    >>
    >>
    >>




+ 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