Forum Discussion
Solved
FILTER and LARGE function.
Hi, I try to extract 10 largest values from a Pivot Table. I write a formula: =INDEX(SORT(FILTER(A:I,(A:A=K2)*(G:G>=LARGE(G:G,10))),7,-1),SEQUENCE(10),{3,7}) The result shows just 3 largest ...
Thank you for your help.
My office version: 2021, it has no TAKE and CHOOSECOLS functions.
I don't know exactly why FILTER and LARGE working incorectly with many dates. If the Pivot Table filter just only date 10, that functions will return the expected result.
- Then just use =INDEX(SORT(FILTER(A:I,(A:A=$K$2)),7,-1),SEQUENCE(10),{3,7}). Omit LARGE() function because SEQUENCE(10) will only show 10 rows.
