+ Reply to Thread
Results 1 to 3 of 3

SORTBY on many columns

  1. #1
    Registered User
    Join Date
    08-08-2018
    Location
    Bangkok
    MS-Off Ver
    MS365 for Mac (latest version)
    Posts
    85

    SORTBY on many columns

    Hello Gurus,

    I have a file with 20+ Companies and 4 columns of Data for each
    I want to make 4 tables where they are sorted descending according to each data.

    My first criteria is an easy SORTBY because the company and data column are next to each other, BUT for the others? is there a simpler way than a SORTBY for the company name and XLOOKUP for the data?

    File attached on how I did it but i'm sure there is a simpler way?

    Thanks
    Attached Files Attached Files

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: SORTBY on many columns

    Maybe try at

    L7
    =SORTBY(C7:C29,E7:E29,-1)

    M7
    =SORT(E7:E29,,-1)

    or
    =SORT(CHOOSE({1,2},$C$7:$C$29,XLOOKUP(J4,$D$4:$G$4,$D$7:$G$29)),2,-1)
    Attached Files Attached Files

  3. #3
    Forum Expert
    Join Date
    02-10-2019
    Location
    Georgia, USA
    MS-Off Ver
    Office 365
    Posts
    2,831

    Re: SORTBY on many columns

    Just another option to get both L and M in one formula, in L7
    =SORT(FILTER($C7:E29,{1,0,1}),2,-1)

    In N7, try:
    =SORT(FILTER($C7:F29,{1,0,0,1}),2,-1)

    etc.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Extract and sortby in descending order
    By paradise2sr in forum Excel General
    Replies: 5
    Last Post: 01-09-2022, 05:19 AM
  2. Combining FILTER and SORTBY formulas
    By Ctromb in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 11-10-2021, 09:39 AM
  3. [SOLVED] SortBy + Filter Formula
    By ionelz in forum Excel General
    Replies: 9
    Last Post: 10-09-2021, 06:56 AM
  4. [SOLVED] New formulas SORT & SORTBY - can I use it with not neighboring columns?
    By afgi in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 09-28-2021, 07:44 AM
  5. [SOLVED] Sort data using filter or sortby function (excel 365)
    By sunboy in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-25-2021, 04:36 AM
  6. Office 365 SORTBY Function not working with INDIRECT and Office ProPlus
    By ExcelWombat in forum Excel Formulas & Functions
    Replies: 19
    Last Post: 01-13-2021, 01:18 AM
  7. Inserting SORTBY formula in range does not work
    By ABSTRAKTUS in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-19-2020, 11:41 AM

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