Hello,
I don't have much experience in excel and im really stuck with this. So i'd really appreciate your help.
I have this "Database" in excel :
RTLP9.png
What i want to do is to use Excel Formulas to make another table wich lists the TOP 2 of Groups by Sum of Score, including Number of sales.
So the result might look like this :
lCW2j.png
Best i could achieve is to sum the Score by specifying the group in the Excel Formula:
In the future i might have more groups and a larger dataset so i hope you guys can help me to come up with a more generic formula in order to sum by groups and then get the TOP X value.Please Login or Register to view this content.
Regards
Bookmarks