Sorting/filtering excellence

[Deleted]

Hello

I have a massive amount of data to sort. I have tried to simplify the setup below with an example. Is there any expert that can find a solution?

Thanks to @Martin_Angosto that showed me a first smart step!

[#2 · Accepted solution]

@Deleted As per your screenshot, try the following...

#3 Output:

=LET(rowId, XMATCH(B14:B22, E14:E19), IF(ISNA(rowId), "", HSTACK(B14:B22, INDEX(F14:F19, rowId), C14:C22)))

#4 Filtered List:

=FILTER(E14:G19, ISNA(XMATCH(E14:E19, B14:B22)), "[none]")

See attached...

[#3]

Thanks! Very helpful!