• 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.

aggregated table inside excel formula

tomas

Active Member
I know the thing I am trying to achieve can be done with pivot easily. For the sake of reproducibility and consistency of workbook I have a thing I am note sure is doable with formulas.

I have column with categories and second columns is with numerical value. I want formula to output categories in order how they are highlighted in yellow. So categorie B is first because sum of numerical values is the highest. See attached sample file.
 

Attachments

  • Book1.xlsx
    12.1 KB · Views: 7
Back
Top