Forum Discussion

Iron Contributor

Oct 22, 2022

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 ...

FILTER_LARGE.xlsx2.3 MB

excel

Formulas and Functions

Harun24HR
Oct 22, 2022
littlevillage Use TAKE() function.
=TAKE(CHOOSECOLS(SORT(FILTER(A:I,A:A=K2),7,-1),3,7),10)
FILTER_TOP_10.xlsx2.3 MB

Detlef_Lewin

Silver Contributor

Oct 22, 2022

littlevillage

Change > into <.

But you can also use the Top10 filter of the pivot table.