Rank

[KIM Chanthan]

Can anyone help me with some formula?
Please view attached file for more detail.

Thank for help.

 

[NARAYANK991]

Hi ,

See if this is OK.

Narayan

 

[salahuddin]

dear kim chanthan,
simply filter the data. And set the condition of top three.

 

[KIM Chanthan]

Hi ,

See if this is OK.

Narayan

Hi,

Thank for your help, but I don't know why I cannot do like cell A3 and A4.
When I follow your formula, it show only the number the same A2, number 9.

 

[KIM Chanthan]

dear kim chanthan,
simply filter the data. And set the condition of top three.

But I need the formula.

Thank,

 

[shrivallabha]

Hi,

Thank for your help, but I don't know why I cannot do like cell A3 and A4.
When I follow your formula, it show only the number the same A2, number 9.

It is because Narayan has applied array formula on all 3 cells simultaneously. To get the same results, first select A2:A4 and then CSE Narayan's formula. You should get what you want.

Or you can use following construct (normally entered)
=LARGE($B$12:$B$18,ROWS($A$1:A1))
copy down.

 

[KIM Chanthan]

It is because Narayan has applied array formula on all 3 cells simultaneously. To get the same results, first select A2:A4 and then CSE Narayan's formula. You should get what you want.

Or you can use following construct (normally entered)
=LARGE($B$12:$B$18,ROWS($A$1:A1))
copy down.

Thank alot. It works now