CODEWITHSUNDEEP
excelsortingfilterexcel-formula
Ikthezeus
Ikthezeus

Reputation: 105

Excel BYROW sort result

I have got the following data:

Initial 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:

Current output

But the output I want to achieve is:

Desired output

Any help on sorting this filter would be greatly appreciated!

Upvotes: 0

Views: 95

Answers (1)

Ike
Ike

Reputation: 13014

=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

Upvotes: 1

Related Questions