Forum Discussion
Solved
How can I filter a table with multiple criteria.
Hi, I am trying to filter a Pivot table. I have written a formula: =INDEX(SORT(FILTER(H4:K132,I4:I132>=LARGE(I4:I132,10),""),4,-1),SEQUENCE(10),1) I got the first result succesfully, but next ste...
But it is not the expected result you show in the workbook.
=SORT(FILTER(FILTER(H4:K132,I4:I132>=LARGE(I4:I132,5),""),{1.0.0.1}),2,-1)
yes, Lewin, that's correct. That's the result expect.
But it is not the expected result you show in the workbook.
=SORT(FILTER(FILTER(H4:K132,I4:I132>=LARGE(I4:I132,5),""),{1.0.0.1}),2,-1)