How to sort columns in a particular sequence?

[Lacan]

Hello Guys, 🖐

Keeping formula would like to sort columns in a particular sequence:

1.Sales (descending order);
2.Rank (ascending);
3.Code (descending).

Thank you very much for the help.

2025.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M
1
2
3		PARIS
4		BRICK	NAME	CODE	SALES	RANK		BRICK	NAME	CODE	SALES	RANK
5		300 Lx - PARIS (MÁgua - Norte)	XPTO	D03	4000	1		299 Lx - NEW YORK (MÁgua - Sul)	ABC	D07	6999	3
6		301 Lx - PARIS (Venteira)	FGO	D07	0	2		299 Lx - NEW YORK (MÁgua - Sul)	ABC2	D05	1503	3
7		301 Lx - PARIS (Venteira)	FGO1	D07	1641	2		299 Lx - NEW YORK (MÁgua - Sul)	ABC3	D04	0	3
8		301 Lx - PARIS (Venteira)	FGO2	D04	11955	2		300 Lx - PARIS (MÁgua - Norte)	XPTO	D03	4000	1
9		302 Lx - PARIS (Falagueira)	FGO3	D05	0	4		300 Lx - LONDON (MÁgua - Norte)	XPTO1	D01	0	1
10								300 Lx - LONDON (MÁgua - Norte)	XPTO2	D06	371	1
11								301 Lx - PARIS (Venteira)	FGO	D07	0	2
12								301 Lx - PARIS (Venteira)	FGO1	D07	1641	2
13								301 Lx - PARIS (Venteira)	FGO2	D04	11955	2
14								302 Lx - PARIS (Falagueira)	FGO3	D05	0	4
15
16
20-07-2024 (2)

Cell Formulas
Range	Formula
B5:F9	B5	=FILTER(CHOOSE({1,2,3,4,5},Tabela2[BRICK],Tabela2[NAME],Tabela2[CODE],Tabela2[SALES],Tabela2[RANK]),(ISNUMBER(SEARCH(B3,Tabela2[BRICK]))*(Tabela2[SALES]>=0)))
Dynamic array formulas.

Cells with Data Validation
Cell	Allow	Criteria
B3	List	NEW YORK; LONDON;PARIS

 

[hagia_sofia]

Hello, you may use:

=SORT(FILTER(CHOOSE({1,2,3,4,5},Tabela2[BRICK],Tabela2[NAME],Tabela2[CODE],Tabela2[SALES],Tabela2[RANK]),(ISNUMBER(SEARCH(B3,Tabela2[BRICK]))*(Tabela2[SALES]>=0))),{4,5,3},{-1,1,-1})

 

[Lacan]

Hello, you may use:

=SORT(FILTER(CHOOSE({1,2,3,4,5},Tabela2[BRICK],Tabela2[NAME],Tabela2[CODE],Tabela2[SALES],Tabela2[RANK]),(ISNUMBER(SEARCH(B3,Tabela2[BRICK]))*(Tabela2[SALES]>=0))),{4,5,3},{-1,1,-1})

Dear @hagia_sofia
Hope you are OK!

For small data works fine however for bigger data which is my case doesn´t match properly.
Can you please give a hand?
Thank you very much.

 

[hagia_sofia]

Many thanks for the feedback. Could you please elaborate on what is the problem - it it a performace issue (it calculates slowly) or something else?

 

[Lacan]

Many thanks for the feedback. Could you please elaborate on what is the problem - it it a performace issue (it calculates slowly) or something else?

Dear @hagia_sofia

Sorry it works fine!!!
My main table in the Ranking Column data it was not converted in number format so the formula doesn´t matched the correct results.
However maybe you can let me know if it is possible to use the comparison operators ( > , < , >= , <= ) not directly in the formula or individually in a unique cell?
Thank you very much.