Forum Discussion
Solved
Filtering only certain columns of a row to another worksheet
I am using Filter to move a copy of the data from one worksheet to another, but want to remove certain columns. Filter does not seem to allow that kind of manipulation. Is this even possible. ...
See the attached workbook. It demonstrates two solutions:
- Using a second FILTER function, with an array of 0s and 1s. For each column returned by the inner FILTER function, 0 means omit this column, 1 means include it.
- Using the CHOOSECOLS function. In this formula, you have to specify the index numbers of the columns you want to include.
See the attached workbook. It demonstrates two solutions:
- Using a second FILTER function, with an array of 0s and 1s. For each column returned by the inner FILTER function, 0 means omit this column, 1 means include it.
- Using the CHOOSECOLS function. In this formula, you have to specify the index numbers of the columns you want to include.
Perfect HansVogelaar thanks so much.