Oct 22 2022 12:28 AM
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 values:
Hope for your help.
Thank you.
Oct 22 2022 12:42 AM
Oct 22 2022 01:48 AM
SolutionOct 22 2022 02:26 AM - edited Oct 22 2022 02:28 AM
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.
Oct 22 2022 03:04 AM
Oct 22 2022 04:15 AM
Oct 22 2022 01:48 AM
Solution