Welcome to Excel Jet Consult blog post. In this Excel video tutorial, I demo how to write a single formula that SORT, Reorder and FILTER Non-contiguous columns with multiple criteria in Microsoft Excel. Do find the practice file download link: Single formula to Sort, Reorder & Filter Non-Contiguous Columns Columns
Video