SORTBY formula

[Nawar Jameel]

Hello

I've got this formula (=IFERROR(LET(u,UNIQUE(FILTER(Raw_Data!$C$2:$C$50007,Raw_Data!$A$2:$A$50007=A14)),IFERROR(TRANSPOSE(SORTBY(u,XMATCH(LEFT(u),{"C","P","CR"}))),"")),""))

Which currently give me this result

I need the outcome to be

I tried SMALL / LARGE formula but did not work out

Any help please

Thanks

 

[ISY]

Hi

=BYCOL(SORT(SORT(VSTACK(LEFT(A2:G2),MID(A2:G2,2,20)),2,1,1),1,-1,1);LAMBDA(W,CONCAT(W)))

 

[Nawar Jameel]

Hi

=BYCOL(SORT(SORT(VSTACK(LEFT(A2:G2),MID(A2:G2,2,20)),2,1,1),1,-1,1);LAMBDA(W,CONCAT(W)))

Unfortunately, it did not work out (=BYCOL(SORT(SORT(VSTACK(LEFT(Raw_Data!$C$2:$C$50007),MID(Raw_Data!$C$2:$C$50007,2,20)),2,1,1),1,-1,1);LAMBDA(W,CONCAT(W))))

Any further solutions please

Thanks

 

[hagia_sofia]

This one particular row is solvable e.g. via CHOOSECOLS and/or SEQUENCE but what is the general rule here? E.g. if the formula returns something that starts with CR or P02?

 

[ISY]

Hi

=BYCOL(SORT(SORT(VSTACK(LEFT(A2:G2),MID(A2:G2,2,20)),2,1,1),1,-1,1),LAMBDA(W,CONCAT(W)))

hagia_sofia
E.g. if the formula returns something that starts with CR or P02?

Something different, you can always divide it with a dedicated formula

 

[Nawar Jameel]

Hi

=BYCOL(SORT(SORT(VSTACK(LEFT(A2:G2),MID(A2:G2,2,20)),2,1,1),1,-1,1),LAMBDA(W,CONCAT(W)))

hagia_sofia
E.g. if the formula returns something that starts with CR or P02?

Something different, you can always divide it with a dedicated formula

Hello ISY

Thanks for your reply

My formula is working OK but the results on rows are from (right to left) instead of (left to right)

For example, what I am getting now the results on rows as follows:

CR01

C04

C03

C02

C01

P02

P01

What I need are the same results on rows but on reverse only

P01

P02

C01

C02

C03

C04

CR01

Below is the formula

=IFERROR(LET(u,UNIQUE(FILTER(Raw_Data!$C$2:$C$50007,Raw_Data!$A$2:$A$50007=A14)),IFERROR(TRANSPOSE(SORTBY(u,XMATCH(LEFT(u),{"C","P","CR"}))),"")),"")


Hoping the above clarification meets your requirements.

Thank you very much.

 

[RoryA]

You can't use LEFT(u) to match against "CR" since it only returns one character.

 

[hagia_sofia]

Like this?

SORTBY(SORT(u,,,TRUE),XMATCH(LEFT(SORT(u,,,TRUE),2),{"P0","C0","CR"}))