1. You are viewing our forum as a guest. For full access please Register. WindowsBBS.com is completely free, paid for by advertisers and donations.

Question About "Ranking" in Microsoft Excel

Discussion in 'Other PC Software' started by neutropia, 2006/10/28.

  1. 2006/10/28
    neutropia

    neutropia Well-Known Member Thread Starter

    Joined:
    2002/08/26
    Messages:
    52
    Likes Received:
    0
    Hey everyone,
    Odd question here.

    Is there any way to have Excel automatically assign a sort of position or number based on where it is in an order of other numbers?

    Say I have: 25%, 73%, 49%

    Now I want it to assign a 1 (or 1st) to the 73%, then a 2 to the 49% and 3 to the 25%.

    Does Excel do anything like this, or will I just have to manually compare and assign the numbers?

    Thanks all!
     
    neutropia,
    #1
  2. 2006/10/29
    Gordon

    Gordon Well-Known Member

    Joined:
    2002/05/22
    Messages:
    117
    Likes Received:
    2
    I don't use Excel, but in Lotus 123 the @Rank function will do what you want.
    @RANK(item;range;[order]) calculates the relative size or position of a value in a range relative to other values in the range.

    Look in the Excel help text and see if Excel has a Rank function also.

    Gordon
     
    Gordon,
    #2


  3. to hide this advert.

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...