Search code examples
sortinggoogle-sheetsgoogle-sheets-formula

Array Sort and Index Largest Value to Smallest Google Sheet

I have database in data google sheet and it has four columns as below:

enter image description here

In column T (Frequency After Sort), I want to sort from largest value to smallest. I use formula and it worked. The formula in below:

=IFERROR(LARGE($R$2:$R; ROW(1:1)); "")

But i got problem, i did not found formula how to index column S (Key Sheet After Sort) to column Q based on column T. Before that i created formula and it not worked. The formula in below:

=INDEX($Q$2:$Q; MATCH(T2; $R$2:$R; 0))

enter image description here

Can somebody help me with this please? Especially in the column S. Later, i will use column S and T to make Pareto Chart. Please let me know.

Solution

  • Use SORT() function instead without having that extra column created by LARGE() function. Try-

    =SORT(R2:S,1,0)