How To Extract And Sort A Dynamic List Of Non Contiguous Columns In Excel
In this tutorial we will take a look at how to extract a dynamic list that has multiple columns but the columns are not contiguous with the ones that I want to extract, and we will do this all with one formula, and also sort those based on the criteria of one of the columns.
To download the file and follow along, go to the link on my website at:
https://app.box.com/file/745984948050...
Do you need help with a formula or an Excel project?
You can send me an e-mail to [email protected]
Including a sample file is always helpful!
You can donate to my channel through any of the following:
PayPal:
https://paypal.me/ExcelBytes?locale.x...
Zelle or Venmo:
Send to [email protected]
This is a trick I learned from Leila Gharani from XelPlus and I'll put a link to her version of this below:
https://www.xelplus.com/excel-filter-...