Need Help in Excel formula - Product wise large to small

Question

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

Answer 1

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

---

=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)),"")

---