Remove all 'False' from spilled data

[CV12]

Hi everyone,

I would like to remove a lot of 'False' in my spilled data. Is there any way to do this? So that only my values will be left?

Criterium C = =N(OFFSET(INDIRECT("'"&TRANSPOSE(Sheets)&"'!C1:C30000");ROW(Summary!$1:$30000)-1)
Criterium = =N(OFFSET(INDIRECT("'"&TRANSPOSE(Sheets)&"'!A1:A30000");ROW(Summary!$1:$30000)-1)
ResultE = =N(OFFSET(INDIRECT("'"&TRANSPOSE(Sheets)&"'!E1:E30000");ROW(Summary!$1:$30000)-1)

Thanks in advance!!!

Test.xlsx
	N	O	P
25	FALSE	FALSE
26	5.00	FALSE
27	0.00	FALSE
28	0.00	FALSE
29	-0.01	FALSE
30	-0.02	FALSE
31	-0.03	FALSE
32	-0.04	FALSE
33	-0.05	FALSE
34	-0.05	FALSE
35	-0.10	FALSE
36	-0.15	FALSE
37	-0.19	FALSE
38	-0.24	FALSE
39	-0.25	FALSE
40	-0.27	FALSE
41	-0.29	FALSE
42	-0.30	FALSE
43	-0.31	FALSE
44	-0.32	FALSE
45	-0.32	FALSE
46	FALSE	FALSE
47	FALSE	FALSE
48	FALSE	FALSE
49	FALSE	FALSE
50	FALSE	FALSE
51	FALSE	FALSE
52	FALSE	FALSE
53	FALSE	FALSE
54	FALSE	FALSE
55	FALSE	FALSE
Summary

Cell Formulas
Range	Formula
N25:O30024	N25	=IF(CriteriumC=B65,(IF(Criterium>=$B$48,IF(Criterium<=$B$49,ResultE))))
Dynamic array formulas.

 

[Fluff]

Try

=IF((CriteriumC=B65)*(Criterium>=$B$48)*(Criterium<=$B$49),ResultE,"")

 

[CV12]

Fluff,

It seems to work, but it only removes the 'False' to a blanco cell. Is it also possible to actually remove the 'False' and only have a spill column of data left?

 

[Fluff]

What would you expect to see?

 

[CV12]

Only the actual values in the spilled column.

Now, the spilled data goes down 30k rows with empty cells. I only need the 20 numbers.

Test.xlsx
	P	Q
25
26		-0.01
27		-0.01
28		-0.03
29		0.23
30		0.62
31		1.15
32		1.88
33		2.03
34		2.17
35		2.92
36		3.62
37		4.30
38		4.98
39		5.14
40		5.41
41		5.68
42		5.89
43		6.08
44		6.26
45		6.26
46
47
48
49
50
51
52
53
54
55
Summary

Cell Formulas
Range	Formula
P25:Q30024	P25	=IF((CriteriumC=B65)*(Criterium>=$B$48)*(Criterium<=$B$49),ResultE,"")
Dynamic array formulas.

 

[Fluff]

Maybe

=LET(a,IF((CriteriumC=B65)*(Criterium>=$B$48)*(Criterium<=$B$49),ResultE,""),FILTER(a,INDEX(a,,1)<>""))

 

[CV12]

Hmm,

It's a complex one.
Now it doesn't go 30k rows down, but keeps one of two the filtered out 20 values. So 2 columns of 20 cells, and only 1 column contains numbers.
I guess I need to build in a filter?

Let me figure this out..

Results.xlsx
	V	W
25		-0.01
26		-0.01
27		-0.03
28		0.23
29		0.62
30		1.15
31		1.88
32		2.03
33		2.17
34		2.92
35		3.62
36		4.30
37		4.98
38		5.14
39		5.41
40		5.68
41		5.89
42		6.08
43		6.26
44		6.26
Summary

Cell Formulas
Range	Formula
V25:W44	V25	=LET(a,IF((CriteriumC=B65)*(Criterium>=$B$48)*(Criterium<=$B$49),ResultE,""),FILTER(a,INDEX(a,,2)<>""))
Dynamic array formulas.