filter and sortby

[ExcelNewbie2020]

I would like to filter the qty with more than 0, then use sortby to sort by dept. would it be possible?

testing.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	Name	no.	section	dept	qty						expected result
2	Name1	1	ZA	Z	5			SORTBY			Name	no.	dept	qty
3	name2	2	AB	A	10			Z			Name1	1	Z	5
4	Name3	3	CD	C	0			A			name2	2	A	10
5	Name4	4	DE	D	20			X			Name7	7	X	6
6	Name5	5	BC	B	5			B			Name5	5	B	5
7	Name6	6	EF	E	4			C			Name10	10	B	32
8	Name7	7	XY	X	6			D			Name4	4	D	20
9	Name8	8	TU	T	0			T			Name9	9	D	12
10	Name9	9	DE	D	12			E			Name6	6	E	4
11	Name10	10	BC	B	32
12
13
14
15
16
17
18
Sheet11

 

[Fluff]

How about

=LET(f,FILTER(CHOOSECOLS(A2:E100,1,2,4,5),E2:E100<>0),SORTBY(f,MATCH(INDEX(f,,3),H3:H10,0)))

 

[ExcelNewbie2020]

How about

=LET(f,FILTER(CHOOSECOLS(A2:E100,1,2,4,5),E2:E100<>0),SORTBY(f,MATCH(INDEX(f,,3),H3:H10,0)))

thanks man..it works..

 

[Fluff]

You're welcome & thanks for the feedback.