Using LARGE to sort results of a SUMIF

[Morovic]

Hi everyone, i need help.
I’m trying to sort the result of a SUMIF function using LARGE but i’ve ancounter a small problem.
I have two columns, A1:A100 contains random week days and B1:B100 contains a numeric value for each day.
Example
A______B
Monday______45
Saturday______16
Thursday______0
etc
My formula is

{=LARGE(SUMIF($A$1:$A$100; $A$1:$A$100; $B$1:$B$100); ROW($A1))}

placed on C1 to C100

it works for the first cell, correctly filled with the highest result, but from second cell onward it gives always the the same 1st larger result.

I think I understood why it does that but i can’t figure a way to work around it
Thank you

[karolus]

Hallo

Enter Monday into E1…pull down to E7.
Enter =SUMIF(A$1:A$100;E1;B$1:B$100) into F1 …pulldown to F7

sort descending E1:F7 by F

[Morovic]

thank you karolus for your answer but i’m trying to build a dynamic column without the need to sort the results by menu command.
I would like to sort it by formula so the ranked placement change accordingly

[karolus]

Try the attached File:
pivot_sort_by_value.ods (25.5 KB)

Setting to sort by Value doubleclick tag ⇒ Options: