Results 1 to 5 of 5

Sorting Results from VSTACK, FILTER with CHOOSECOLS

Threaded View

  1. #4
    Registered User
    Join Date
    11-28-2023
    Location
    BC, Canada
    MS-Off Ver
    MS 365
    Posts
    2

    Re: Sorting Results from VSTACK, FILTER with CHOOSECOLS

    Thanks Fluff13! Your solution was almost perfect.
    The sort was in the wrong spot as it included the column headings...made the following change and it sorts correctly.

    =CHOOSECOLS(VSTACK(Table1[#Headers],SORT(FILTER(Table1,Table1[New Assign?]=Sheet6!C4,""),{4,3},{-1,1})),2,5,6,8,9)

    I didn't know how the SORT function and {} brackets work with an array. Excellent info!
    Last edited by drvs; 11-28-2023 at 04:42 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. CHOOSECOLS and add a blank column
    By elischwa in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-22-2024, 03:13 PM
  2. [SOLVED] Add Additional FILTER to VSTACK
    By BiblioManiac in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-22-2023, 03:32 PM
  3. Take,ChooseCols,Sort Function Not Showing Output In A Particular Cell
    By quentinlemmer in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 07-07-2023, 08:52 AM
  4. VSTACK results of indirect references from an array
    By tdarenkov in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-16-2023, 04:11 AM
  5. [SOLVED] Problem when filter named ranges using VSTACK
    By oteixeira in forum Excel General
    Replies: 6
    Last Post: 01-18-2023, 03:37 PM
  6. Replies: 3
    Last Post: 04-27-2017, 05:25 PM
  7. Replies: 3
    Last Post: 03-31-2010, 11:47 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