+ Reply to Thread
Results 1 to 4 of 4

Sort data in several columns without using pivot table

  1. #1
    Registered User
    Join Date
    05-04-2018
    Location
    nairobi
    MS-Off Ver
    ms office 2010
    Posts
    14

    Sort data in several columns without using pivot table

    Hi. Am trying to sort values in several columns but based on values in one of the columns (COLUMN D) in descending order using a formula. Attached is a workbook named SAMPLE 5 with raw data in a worksheet named TEST. Expected results are in a different worksheet named RESULTS.
    I would be grateful for your assistance. Thanks
    Attached is my workbook, named SAMPLE 5
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    06-08-2012
    Location
    swindon, england
    MS-Off Ver
    Excel 2019 / Windows 10
    Posts
    4,876

    Re: Sort data in several columns without using pivot table

    Quote Originally Posted by KIBAAKO View Post
    Am trying to sort values in several columns but based on values in one of the columns (COLUMN D) in descending order using a formula.
    Is that correct, or should it be column E?

  3. #3
    Registered User
    Join Date
    05-04-2018
    Location
    nairobi
    MS-Off Ver
    ms office 2010
    Posts
    14

    Re: Sort data in several columns without using pivot table

    Am very sorry, you are right, it should Column E. Thanks

  4. #4
    Forum Expert
    Join Date
    06-08-2012
    Location
    swindon, england
    MS-Off Ver
    Excel 2019 / Windows 10
    Posts
    4,876

    Re: Sort data in several columns without using pivot table

    Not a problem, an easy mistake to make.

    Try entering this formula into E4
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    this one into A4, then fill right to D4
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    and this one into F4, then fill right to AB4
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    finally, fill all of them down about 100 rows.
    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)

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