Forum Discussion
How can I use filter and remove columns?
I have a spreadsheet with columns A through BX and rows of only a few hundred. I have used =FILTER() in a 2nd tab to provide a referenced and filtered list of subset of data from the primary data so...
It depends on where the desired columns are in the array. You might use TAKE or DROP if the columns are on the ends or CHOOSECOLS, if the columns are not next to each other.