Forum Discussion
Sorting/filtering excellence
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 f...
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...
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...
Thanks! Very helpful!