How to Use SortBy function?

[BrettOlbrys1]

I have the following formula:

=INDEX(SORT(FILTER('Activations Table'!$BH$3:$BJ$5000,('Activations Table'!$BH$3:$BH$5000<>"")*('Activations Table'!$BJ$3:$BJ$5000<>0)),3,-1),SEQUENCE('Activations Table'!$BH$1),{1})

The formula is looking at a table of 3 columns of data:

Column BH - name 1
Column BI - name 2
Column BJ - qty

The formula arranges the names in column BH based on the quantities in column BJ (from greatest to least), and the formula works as expected. But I also want to use the data in column BI as a sorting point (not just column BJ) so that the results will be like this:

Sort first by column BI (alphabetically ascending), but within that sort I want each of the same names in column BI to be sorted by the quantities in column BJ from greatest to least.

How do I modify the above formula to make this work?

Thanks

Brett

 

[RoryA]

Try:

=INDEX(SORT(FILTER('Activations Table'!$BH$3:$BJ$5000,('Activations Table'!$BH$3:$BH$5000<>"")*('Activations Table'!$BJ$3:$BJ$5000<>0)),{2,3},{1,-1}),SEQUENCE('Activations Table'!$BH$1),{1})

 

[Fluff]

How about

=TAKE(SORT(FILTER('Activations Table'!$BH$3:$BJ$5000,('Activations Table'!$BH$3:$BH$5000<>"")*('Activations Table'!$BJ$3:$BJ$5000<>0)),{2,3},{1,-1}),'Activations Table'!$BH$1,1)

 

[BrettOlbrys1]

Try:

=INDEX(SORT(FILTER('Activations Table'!$BH$3:$BJ$5000,('Activations Table'!$BH$3:$BH$5000<>"")*('Activations Table'!$BJ$3:$BJ$5000<>0)),{2,3},{1,-1}),SEQUENCE('Activations Table'!$BH$1),{1})

PERFECT! Thank you.

 

[RoryA]

Glad we could help.