excelexcel-formulaexcel-2013

Need Help in Excel formula - Product wise large to small


enter image description here

How to get output in excel thru formula.

Pls. help.

I am trying with excel formula.

Total 5 product quantity list.

Need to arrange highest to lowest wise with product name.

If Duplicate then like (10 , 10 ) then select pro. 2 and pro.3

Need Help in Excel formula - Product wise large to small


Solution

  • Try using the following formula, which should work with the version of Excel you are using. Also while exiting the edit mode, you would need to hit CTRL+SHIFT+ENTER

    enter image description here


    =IFERROR(INDEX($A$2:$E$2,MATCH(SMALL(
     IFERROR(RANK($A3:$E3,$A3:$E3)+COLUMN($A$2:$E$2)/1000,""),COLUMNS($G3:G3)),
     IFERROR(RANK($A3:$E3,$A3:$E3)+COLUMN($A$2:$E$2)/1000,""),0)),"")