Using output of LAMBDA within a function

[sharshra]

I´m making use of LAMBDA function to do a simple repeating job. In the 2nd step, I want to use the output of this function to do another validation. Is it possible to embed the functionality of the 2nd step within the first function?

Consider the following example. LAMBDA function 'f' filter out the blank row. It results in 0 where there is no value in the corresponding column. In this case, there are 3 zeros. I want to use SUBSTITITE function to replace 0 with blanks. At present, I´m doing it in a separate step. Instead, I want this to be part of the first function 'f'.

Source table:

excel problems.xlsx
	B	C	D	E
2	id	desc	name	email
3	9	bl	dfs	kjdkjd
4	9	ec	ewq
5	1	mm		oiw
6	1	dd	jfjf
7	5	w	ti	kdf
8	5	fx	qrqw
9	5	mt	xb
10	5	ij	vm
11	5	gt		jdsf
12	10	hp
13	10	72	dsfa
14	10	fv		qwrq
lambda functions

Filtered table:

excel problems.xlsx
	F	G
3	dfs	kjdkjd
4	0	oiw
5	ti	kdf
6	0	jdsf
7	0	qwrq
lambda functions

Cell Formulas
Range	Formula
F3:G7	F3	=LET( f,LAMBDA(filterArray,filterCondition, FILTER(filterArray,filterCondition<>OR("",0),"")), s,f($D$3:$E$14,$E$3:$E$14), s)
Dynamic array formulas.

Desired output (using SUBSTITUTE separately):

excel problems.xlsx
	F	G
3	dfs	kjdkjd
4		oiw
5	ti	kdf
6		jdsf
7		qwrq
lambda functions

Cell Formulas
Range	Formula
F3:G7	F3	=LET( f,LAMBDA(filterArray,filterCondition, FILTER(filterArray,filterCondition<>OR("",0),"")), s,f($D$3:$E$14,$E$3:$E$14), SUBSTITUTE(s,0,""))
Dynamic array formulas.

 

[sharshra]

Oops....I figured it out. Thanks.

 

[StephenCrump]

I'm glad you figured it out.

But you could also do it very simply as: =LET(f,FILTER(D3:E14,E3:E14<>""),IF(f=0,"",f))

 

[Phuoc]

Another option:

=FILTER(D3:E14&"",E3:E14<>"")