Forum Discussion
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...
This workaround is good for some basic stacking:
=SORT(IF({1,0},UNIQUE(A3:A7),SUMIFS(B3:B7,A3:A7,UNIQUE(A3:A7))),2,-1)
This is helpful thank you.