+ Reply to Thread
Results 1 to 3 of 3

Sort order (ranking) for miltiple columns of data

  1. #1
    Registered User
    Join Date
    12-05-2006
    Posts
    29

    Sort order (ranking) for miltiple columns of data

    Hi, I am hoping someone can help me with a more efficient way to achieve what I am currently doing longhand.

    I have columns A:K all with say 20 rows of data in them. I want to insert a blank column between each of the columns with data in in and then basically denote where the cell on the left sorts/ranks with respect to all the data in the column on the left.

    Previously I have sorted by column A from largest to smallest and then typed in 1, 2, 3 etc into column B and dragged it down to the 20th row. Then for the data in column C, inserted a column to its right (D), sorted by C (largest to smallest), typed 1 into row 1, 2 into row 2 and dragged it down to the 20th row. And so on.

    I'm hoping there's a function I can insert into columns B and D etc to do all this for me without having to manually sort columns A, C, E etc.

    Attached is a sample of what I am referencing. The yellow columns are the ones I want to automate.

    Does anyone have any ideas that may help me?

    Thanks in advance.

    Greg.
    Attached Files Attached Files
    Last edited by plannerg; 10-19-2010 at 05:37 AM.

  2. #2
    Forum Guru teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Sort order (ranking) for miltiple columns of data

    Hello Greg,

    in B1 use

    =RANK(A1,A$1:A$20)

    copy down. Then copy the formula to D1 and F1 and copy down the respective columns.

    cheers

  3. #3
    Registered User
    Join Date
    12-05-2006
    Posts
    29

    Re: Sort order (ranking) for miltiple columns of data

    Spot on. Thank you.

+ 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