Forum Discussion
FILTER with SEARCH Function Question
NSUMike When you select the entire table as the filter array, all columns will be returned by FILTER. Extend the array code by the first and last column you want to display for.
In you case that would become:
VSTS_4914e127_bdaf_4bc3_8508_05512d20d6a1[[ID]:[Full Name]]
If you would want to return only the first and third column, use your original formula but wrap it in another FILTER adding a "mask" of columns that should be returned between curly brackets. Any number not equal to zero=include, 0=exclude). Something like this:
=FILTER(FILTER(..................),{1,0,1,0,0})
NSUMike When you select the entire table as the filter array, all columns will be returned by FILTER. Extend the array code by the first and last column you want to display for.
In you case that would become:
VSTS_4914e127_bdaf_4bc3_8508_05512d20d6a1[[ID]:[Full Name]]
If you would want to return only the first and third column, use your original formula but wrap it in another FILTER adding a "mask" of columns that should be returned between curly brackets. Any number not equal to zero=include, 0=exclude). Something like this:
=FILTER(FILTER(..................),{1,0,1,0,0})
- Fantastic! That worked like a charm. I learn a little bit more every day. Thank you so much.
