Forum Discussion

yennek's avatar
yennek
Copper Contributor
Dec 11, 2022
Solved

How to sort the unique() values by their sumifs()

From a large data set, I’m generating a list of unique names with =UNIQUE(...). Next to those unique names there’s a simple =SUMIFS(...) giving the totals. All is good. I can use =Sort(Unique(...)) t...
excel
Formulas and Functions
office 365
  • Harun24HR's avatar
    Harun24HR
    Dec 12, 2022

    yennek All you can do in a single formula. Try the following formula.

    =SORT(HSTACK(UNIQUE(A3:A7),SUMIFS(B3:B7,A3:A7,UNIQUE(A3:A7))),2,-1)

     See the attached file.

     

Wasel_Housami's avatar
Wasel_Housami
Copper Contributor
Jan 01, 2025

WONDERFUL THANK YOU

I have two questions

1- can I get the result of that values bigger than 2?

2- how to do a conditional formatting for the exact resalt table without selecting too many cells?

Resources