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!
Bookmarks