Results 1 to 4 of 4
  1. #1
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Illinois
    Posts
    552
    Thanks
    0
    Thanked 1 Time in 1 Post

    Sorting questions (Excel 2003)

    I have the attached sheet that is sorted by COL E. I need to put in the rank number (1-51) in COL B of COL C's sorting. So Row 16's COL C is 2.59 and is the highest number in COL C so it's rank will be 1 in COL B. Is there a formula I can use to get the other numbers? Thank you for the help.
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Sorting questions (Excel 2003)

    You can use the RANK function for this: enter the following formula in B2

    =RANK(C2,$C$2:$C$52)

    and fill down to B52 (or select B2:B52, enter the formula and confirm it with Ctrl+Enter)

  3. #3
    3 Star Lounger
    Join Date
    May 2002
    Location
    Mpls, Minnesota, USA
    Posts
    271
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sorting questions (Excel 2003)

    The formula =Rank should do the job.

    Chuck
    Chuck Reimer
    I'm from the Government and I'm here to help...

  4. #4
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Illinois
    Posts
    552
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Sorting questions (Excel 2003)

    Thank you for the help. Worked great

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •