Рет қаралды 3,530
Here is how to use Microsoft Excel FILTER Function to include only the columns that you want to return, to filter out what you don't want:
Use another FILTER Function, for the include argument, open the curly brackets and flag out the columns that you want to keep using 1 and 0.
For Excel 1 = TRUE and 0 = FALSE