• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Problem Sort Data by Sum of Total Amount

P

Paijo

New Member
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
 

Attachments

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,
 
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
 
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
 
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
 
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
 

Attachments

You must log in or register to reply here.
Back
Top