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