Is it possible to add blank columns in Choosecols return

[btardo01]

Can I use the choosecols function and bring in column 2, then leave a blank column, then bring in column 11, then 2 blank columns, and the bring in column 21 and 15?

=CHOOSECOLS(FILTER('EPM Report'!A:S,('EPM Report'!P:P<>0)),2," ",11," "," ",21,15),2,1)

 

[kevin9999]

If you expand the array to include a blank column at the end of the range, you could use it like this:

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U
1	HDR1	HDR2	HDR3	HDR4	HDR5	HDR6	HDR7	HDR8	HDR9	HDR10	HDR11	HDR12	HDR13	HDR14	HDR15	HDR16	HDR17	HDR18	HDR19	HDR20	HDR21
2	Col: 1	Col: 2	Col: 3	Col: 4	Col: 5	Col: 6	Col: 7	Col: 8	Col: 9	Col: 10	Col: 11	Col: 12	Col: 13	Col: 14	Col: 15	1	Col: 17	Col: 18	Col: 19	Col: 20	Col: 21
3	Col: 1	Col: 2	Col: 3	Col: 4	Col: 5	Col: 6	Col: 7	Col: 8	Col: 9	Col: 10	Col: 11	Col: 12	Col: 13	Col: 14	Col: 15	2	Col: 17	Col: 18	Col: 19	Col: 20	Col: 21
4	Col: 1	Col: 2	Col: 3	Col: 4	Col: 5	Col: 6	Col: 7	Col: 8	Col: 9	Col: 10	Col: 11	Col: 12	Col: 13	Col: 14	Col: 15	3	Col: 17	Col: 18	Col: 19	Col: 20	Col: 21
5	Col: 1	Col: 2	Col: 3	Col: 4	Col: 5	Col: 6	Col: 7	Col: 8	Col: 9	Col: 10	Col: 11	Col: 12	Col: 13	Col: 14	Col: 15	0	Col: 17	Col: 18	Col: 19	Col: 20	Col: 21
6	Col: 1	Col: 2	Col: 3	Col: 4	Col: 5	Col: 6	Col: 7	Col: 8	Col: 9	Col: 10	Col: 11	Col: 12	Col: 13	Col: 14	Col: 15	1	Col: 17	Col: 18	Col: 19	Col: 20	Col: 21
7	Col: 1	Col: 2	Col: 3	Col: 4	Col: 5	Col: 6	Col: 7	Col: 8	Col: 9	Col: 10	Col: 11	Col: 12	Col: 13	Col: 14	Col: 15	2	Col: 17	Col: 18	Col: 19	Col: 20	Col: 21
8	Col: 1	Col: 2	Col: 3	Col: 4	Col: 5	Col: 6	Col: 7	Col: 8	Col: 9	Col: 10	Col: 11	Col: 12	Col: 13	Col: 14	Col: 15	3	Col: 17	Col: 18	Col: 19	Col: 20	Col: 21
9	Col: 1	Col: 2	Col: 3	Col: 4	Col: 5	Col: 6	Col: 7	Col: 8	Col: 9	Col: 10	Col: 11	Col: 12	Col: 13	Col: 14	Col: 15		Col: 17	Col: 18	Col: 19	Col: 20	Col: 21
10	Col: 1	Col: 2	Col: 3	Col: 4	Col: 5	Col: 6	Col: 7	Col: 8	Col: 9	Col: 10	Col: 11	Col: 12	Col: 13	Col: 14	Col: 15	1	Col: 17	Col: 18	Col: 19	Col: 20	Col: 21
11	Col: 1	Col: 2	Col: 3	Col: 4	Col: 5	Col: 6	Col: 7	Col: 8	Col: 9	Col: 10	Col: 11	Col: 12	Col: 13	Col: 14	Col: 15	2	Col: 17	Col: 18	Col: 19	Col: 20	Col: 21
12	Col: 1	Col: 2	Col: 3	Col: 4	Col: 5	Col: 6	Col: 7	Col: 8	Col: 9	Col: 10	Col: 11	Col: 12	Col: 13	Col: 14	Col: 15	3	Col: 17	Col: 18	Col: 19	Col: 20	Col: 21
EPM Report

Book1
	A	B	C	D	E	F	G
1	HDR1	HDR2	HDR3	HDR4	HDR5	HDR6	HDR7
2	HDR2		HDR11			HDR21	HDR15
3	Col: 2		Col: 11			Col: 21	Col: 15
4	Col: 2		Col: 11			Col: 21	Col: 15
5	Col: 2		Col: 11			Col: 21	Col: 15
6	Col: 2		Col: 11			Col: 21	Col: 15
7	Col: 2		Col: 11			Col: 21	Col: 15
8	Col: 2		Col: 11			Col: 21	Col: 15
9	Col: 2		Col: 11			Col: 21	Col: 15
10	Col: 2		Col: 11			Col: 21	Col: 15
11	Col: 2		Col: 11			Col: 21	Col: 15
12
Sheet2

Cell Formulas
Range	Formula
A2:G11	A2	=CHOOSECOLS(FILTER('EPM Report'!A:V,'EPM Report'!P:P<>0),2,22,11,22,22,21,15)&""
Dynamic array formulas.

 

[Peter_SSs]

@btardo01
Given your question, could it be time to update your profile version details?