I'm honestly not 100% sure if this is the right place to ask but I have to give it a try so I'm trying to sort by curse and by A -> Z the names but I have try plenty of ways and I never get the correct format and I have google it and they just keep giving useless answers that is not for this specific case.

As you can see I made a custom sort for the curse but I still have no idea how or where to add the A -> Z for the names I always get it wrong and it tells me is wrong. Any advice ?

I have done plenty attempts trying to format it the right way buuut always end in failure an example:

Formula: =ARRAYFORMULA(SORT(DATA!A2:BY101,match(DATA!P2:P101,{"1º";"2º";"3º";"4º";"5º";"6º";"7º";"8º";"9º";"10º";"11º";"12º"},0),TRUE))

CodePudding user response：

try:

=ARRAYFORMULA(SORT(DATA!A2:BY101, MATCH(DATA!P2:P101, 
 {"1º";"2º";"3º";"4º";"5º";"6º";"7º";"8º";"9º";"10º";"11º";"12º"}, 0), 1, 2, 1))