+ Reply to Thread
Results 1 to 8 of 8

Trouble Sorting a filtered index

  1. 07-04-2023, 02:23 PM #1
    Mreilander
    Mreilander is offline
    Registered User
    Join Date
    05-01-2014
    Location
    Canada
    MS-Off Ver
    MS365, Version 2305
    Posts
    12

    Trouble Sorting a filtered index

    Hi All,
    I'm a little stumped with the sort function of this formula...

    =SORT(FILTER(INDEX(OrderData,SEQUENCE(ROWS(OrderData)),{1,3,6,10,11,19,49,15}),OrderData[Order Status]<>"Shipped","Nil"),MATCH(C4,OrderData[#Headers],0),1,FALSE)

    The filter and index work fine, but as soon as I try to apply the sort function, I get #VALUE!

    OrderData is a table on a separate sheet within the workbook.
    C4 has a data validation list that matches specific header titles in the OrderData table.

    I would like it to sort the rows, in ascending order, by the table header that matches the selection in C4

    Any help or insight would be greatly appreciated.
    Reply With QuoteRegister To Reply
  2. 07-04-2023, 02:27 PM #2
    alansidman
    alansidman is offline
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,902

    Re: Trouble Sorting a filtered index

    The SORT function is not part of XL2013.

    Administrative note
    Is your forum profile showing the Excel PRODUCT that you need this request to work with?

    The best solutions often rely on knowing WHICH Office PRODUCT (Excel, NOT Windows) that you have. Please check that your forum profile is up-to-date. If you aren't sure, in Excel go to File/Account and report what it says below the MS logo at the top of that page. If your version is for Mac, please also state this.

    The three most recent Excel PRODUCTS are Excel 2019, Excel 2021 and MS365 - if you are using MS365, please give this name along with the Version number in your profile (e.g. MS365 (PC) Version 2211). The version number is in the About Excel section further down the Account page.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
    Reply With QuoteRegister To Reply
  3. 07-04-2023, 02:42 PM #3
    Mreilander
    Mreilander is offline
    Registered User
    Join Date
    05-01-2014
    Location
    Canada
    MS-Off Ver
    MS365, Version 2305
    Posts
    12

    Re: Trouble Sorting a filtered index

    Hi Alan,
    It is MS365 Version 2305.

    I will update my profile, thank you
    Reply With QuoteRegister To Reply
  4. 07-04-2023, 02:49 PM #4
    Mreilander
    Mreilander is offline
    Registered User
    Join Date
    05-01-2014
    Location
    Canada
    MS-Off Ver
    MS365, Version 2305
    Posts
    12

    Re: Trouble Sorting a filtered index

    See attached sample workbook

    The formula is in A7 of the "Printable Schedule Steel" tab
    Attached Files Attached Files
    Last edited by Mreilander; 07-04-2023 at 02:53 PM.
    Reply With QuoteRegister To Reply
  5. 07-04-2023, 02:51 PM #5
    Fluff13
    Fluff13 is online now
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,097

    Re: Trouble Sorting a filtered index

    The column you are matching is col 19 but you only have 8 columns in the output data, try
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  6. 07-04-2023, 02:58 PM #6
    Mreilander
    Mreilander is offline
    Registered User
    Join Date
    05-01-2014
    Location
    Canada
    MS-Off Ver
    MS365, Version 2305
    Posts
    12

    Re: Trouble Sorting a filtered index

    Quote Originally Posted by Fluff13 View Post
    The column you are matching is col 19 but you only have 8 columns in the output data, try
    Formula: copy to clipboard 
    Please Login or Register  to view this content.

    This seems to have done the trick. Thank you
    Reply With QuoteRegister To Reply
  7. 07-04-2023, 02:59 PM #7
    Fluff13
    Fluff13 is online now
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,097

    Re: Trouble Sorting a filtered index

    You're welcome & thanks for the feedback.
    Reply With QuoteRegister To Reply
  8. 07-04-2023, 05:36 PM #8
    alansidman
    alansidman is offline
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,902

    Re: Trouble Sorting a filtered index

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Trouble with populating ComboBox list with visible cells in filtered range
    By brucemc777 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 02-09-2019, 08:02 PM
  2. Having trouble with vertical page breaks when priting filtered cells
    By mah1r in forum Excel General
    Replies: 0
    Last Post: 05-01-2016, 01:26 AM
  3. [SOLVED] Trouble with sorting
    By rsmithline in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 10-17-2015, 12:45 PM
  4. Trouble copying filtered data to new Workbook- Run-time Error 13
    By izzorac in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-25-2014, 10:45 AM
  5. Trouble with sorting
    By petevang in forum Excel General
    Replies: 3
    Last Post: 11-23-2012, 11:13 AM
  6. still trouble with sorting
    By speedstr in forum Excel Programming / VBA / Macros
    Replies: 43
    Last Post: 05-24-2012, 05:12 PM
  7. [SOLVED] Trouble with Filtered Ranges
    By Rajesh in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-06-2005, 10:50 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1