I have got the following data:

I have filtered the data to remove 0 values using the following:

=FILTER(AE11:AF33,BYROW(AF11:AF33,LAMBDA(a,SUM(a)))>0)

I can't for the life of me sort this filter, my current output is:

But the output I want to achieve is:

Any help on sorting this filter would be greatly appreciated!

CodePudding user response：

=SORT(FILTER(AE11:AF33,AF11:AF33>0),2,-1) will do the filtering and sorting.

Second parameter of the SORT-function takes the column to sort by.

I don't think, that you need the LAMBDA function here