Index match funcion ignoring blank cells

[valmir]

Hi everyone!
I am using these formulas to rank names and the problem I am having is that they are returning blank cells:
=COUNTIF($BZ1:$BZ608;"<="&$BZ1:$BZ608)

=IFERROR(INDEX($BY$1:$CA$608;MATCH(BX1;$CJ$1:$CJ$608;0);1);"")
=IFERROR(INDEX($BZ$1:$BZ$608;MATCH(BX1;$CJ$1:$CJ$608;0);2);"")
=IFERROR(INDEX($BY$1:$BY$608;MATCH(BX1;$CJ$1:$CJ$608;0);3);"")

I have gone through all similar threads and I could not get anything to work
Please help!

Stats 2016.xlsx
	CK
38
STATS2

 

[jasonb75]

Let me check that I'm following correctly, should it be the same results as in columns CG:CI but just sorted differently, or are the blank rows to exclude different?

If it is the same then this might work (if I have the syntax correct this time). You might need to change the last 2 to a 3 if it is sorting on the wrong column.

=SORT(INDEX(CG1#;SEQUENCE(ROWS(CG1#));{1\3\2});2;1)

 

[valmir]

=SORT(INDEX(CG1#;SEQUENCE(ROWS(CG1#));{1\3\2});2;1)

Yes Sir that's it. Now, can I get rid of those rows on the top so that it starts with the first populated middle column?

Stats 2016.xlsx
	CZ	DA	DB
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	SAG	Adérito Yandelela Chissoca 1	Lelas 1
31	MAI	Adérito Yandelela Chissoca 2	Lelas 2
32	INT	Adilson Cipriano da Cruz	Neblú
33	LIB	Adilson Ernesto Kivão	Adilson Kivão
34	CAA	Adilson Joaquim Manuel	Adilson Manuel
35	SAG	Adolfo da Silva Catemba 1	Denilson 1
36	POR	Adolfo da Silva Catemba 2	Denilson 2
37	PRO	Adriano Belmiro Duarte Nicolau	Yano
38	DES	Adriano da Costa Mateus Alberto	Kumaca
39	ASA	Afonso Sebastião Cabungula	Fofó
40	INT	Agostinho Cristóvão Paciência	Mabululu
41	BEN	Agostinho Domingos Paulo	Ady Paulo
42	KAB	Aires Emilson Gonzaga Zeca	Emilson
43	MAI	Albano Camuele Sumano	Pai da Bola
44	PRI	Albert Milambo-Mutamba	Milambo
45	PRI	Alberto Álvaro Paca	Fissy
46	4AB	Alberto dos Santos Domingos	Kizombé
47	SAG	Alentua Tangala Rolli	Rolli
48	POR	Alexandre Domingos Cristóvão M'Futila	Alexandre
STATS2