Question related to Ranking

[Kg Teh]

Dear all,

Can you give me some ideas what formula should I use to auto rank the items based on sales amount ? Please refer attached file for detail information.

Many thanks !

 

[Ratan Bhushan]

Please find attachement

 

[Kg Teh]

Thank you Ratan for your replies.
However, i need the formulas to generate the data as shown in Pink Cells.

 

[Khalid NGO]

Hi,
You can also try:
=MATCH(LARGE($K$6:$K$26,ROW()-5),$K$6:$K$26,0)

Regards,

 

[NARAYANK991]

Hi ,

See this file.

Narayan

 

[Kg Teh]

Thank you Khalid for replies.

Thank you narayank991. It works perfectly. Today i have learnt something new again.