sort index sequence function showing zero values first

[valmir]

Hello everyone
I need help fixing this formula:
=SORT(INDEX(CG1#;SEQUENCE(ROWS(CG1#));{1\3\2});2;1)
As shown below, it is showing the zero values first on the alphabetically sorted column (middle column).
The sorting is supposed to start on row 24.
Thanks

Stats 2016 - Copy.xlsx
	CS	CT	CU
1	ASA	0	Ady ?
2	BEN	0	Anderson
3	PRO	0	Belito ?
4	4AB	0	Borra
5	4AB	0	Cadiata
6	4AB	0	Chara ?
7	PLS	0	Chico Bel
8	SAG	0	Didí
9	PLS	0	Dji
10	4AB	0	Edi
11	MAI	0	Fernandinho
12	MAI	0	Isaías ?
13	4AB	0	Ivanilson
14	4AB	0	Jesse
15	ASA	0	Kelly
16	4AB	0	Lara ?
17	MAI	0	Mano ?
18	PLS	0	Mayala
19	POR	0	Miguel ?
20	ACA	0	Nzuzi
21	4AB	0	Rui ?
22	ASA	0	Tucho ?
23	LIB	0	Yuri ?
24	PLS	Abel Lukango	Abel
25	DES	Abelardo Gomes Socola	Belito Socola
26	DES	Abengea Mambani Ali	Ali
27	DES	Adão Francisco Congo Zalata	Dadão Bile
28	PRI	Adão Joaquim Bango Cabaça	Tony Cabaça
29	CAA	Adelino Wima Calunhi António	Maninho
30	MAI	Adérito Yandelela Chissoca	Lelas
31	SAG	Adérito Yandelela Chissoca	Lelas
32	INT	Adilson Cipriano da Cruz	Neblú
33	LIB	Adilson Ernesto Kivão	Adilson Kivão
34	CAA	Adilson Joaquim Manuel	Adilson Manuel
35	POR	Adolfo da Silva Catemba	Denilson
36	SAG	Adolfo da Silva Catemba	Denilson
37	PRO	Adriano Belmiro Duarte Nicolau	Yano
38	DES	Adriano da Costa Mateus Alberto	Kumaca
39	ASA	Afonso Sebastião Cabungula	Fofó
STATS2

 

[valmir]

My solution works on the spilled range that your formula works on.
I created some scrap data in G1 to represent your data in CG1 & then the formula in L1 is to replace the formula you posted in your op.

In my particular case the column to follow up is CG and on account of language settings I changed the formula to:
=SORT(SORTBY(FILTER(CG1#;INDEX(CG1#;;3)<>0);{1;3;2});2;1)
I am getting a value error. Can you please tell me why?

 

[Fluff]

It may need to be

=SORT(SORTBY(FILTER(CG1#;INDEX(CG1#;;3)<>0);{1\3\2});2;1)

 

[valmir]

=SORT(SORTBY(FILTER(CG1#;INDEX(CG1#;;3)<>0);{1\3\2});2;1)

It worked! Thank you very much for your time and your patience, Sir! ? ?

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[valmir]

Glad we could help & thanks for the feedback.

Before I came to you guys for help I actually paid in another website and they couldn't solve my problem. I hope I could some how donate at least for the website.

 

[Fluff]

Thanks for the offer, however there is no way to donate to the site.