Problem Sort Data by Sum of Total Amount

[Paijo]

Hi experts

I have problem with sort or ranking by SUM of total amount by Names, Im already done with helper column and LARGE function, but is that possible with single formula? I see this forum is the great forum I've ever follow, thanks in advance...

Im attaching file for better explanation

regards

 

[Khalid NGO]

Hi,
Not sure what you are looking for is easy without helper cells

For unsorted result:
This will give you unique list, in cell A11:
=IFERROR(INDEX($A$2:$A$8,MATCH(0,COUNTIF($A$10:A10,$A$2:$A$8),0)),"")
with Ctrl+Shift+Enter

This in B11:
=SUMIF($A$2:$A$8,A11,$B$2:$B$8)
Copy down both

Regards,

 

[NARAYANK991]

Hi ,

See this file.

Narayan

 

[Paijo]

Hello thanks Khalid for the post but I need the highest for the total amount based on names, sorry if I not clear in the first place, For Narayan you're the man bro, that's exactly that I need.

Thanks Khalid and Narayan, God Bless you all

 

[prasaddn]

Hi ,

See this file.

Narayan

Hi Narayan,

how would the formula be different for a situation where you have two or more names with same total?

Regards,
Prasad

 

[NARAYANK991]

Hi Prasad ,

In that case , I doubt that it could be done without using a helper column , since the SUMIF by itself will handle only the numeric data , and the name data cannot be incorporated ; if a FREQUENCY function could be used , so that the name totals are only associated with the first occurrence of each name , that would work , but off-hand I cannot think of the resulting formula.

Narayan

 

[prasaddn]

NP narayan. Thank you

 

[XOR LX]

Perhaps Narayan is right, though it sounds like a nice challenge!

Would it be possible to have some updated sample data on which to test solutions?

Regards

 

[NARAYANK991]

Hi ,

Knowing you I am sure you will soon post a solution !

The worst-case scenario would be if all of them had the same scores total.

Of course , we can add more names and scores to see how the lower ranks would be handled.

Narayan

 

[John Jairo V]

Hi to all!

I post a Solution with a Name Formula (for easy reading and shorter formula).
Blessings!