**Question description:**

*This user has given permission to use the problem statement for this blog.*

Sir I have 2 column A bank name B Revenue I want to get who bank name revenue in top and who in second

Solved by G. Y. in 25 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
23/03/2018 - 01:41

Hi buddy

Excelchat Expert
23/03/2018 - 01:41

Welcome to got it pro

User
23/03/2018 - 01:42

Hi

User
23/03/2018 - 01:42

Sir

Excelchat Expert
23/03/2018 - 01:43

Hi buddy

User
23/03/2018 - 01:43

Sir this is my question

User
23/03/2018 - 01:43

I have no file for attach

User
23/03/2018 - 01:44

Sir pls give me answer

User
23/03/2018 - 01:45

I have 2 column A bank name and B Revenue I want to know that who bank in top in revenue

Excelchat Expert
23/03/2018 - 01:46

Ok, is my example alright?

User
23/03/2018 - 01:46

And who in 2nd who in 3rd I have 20 bank so I want to rank all bank

Excelchat Expert
23/03/2018 - 01:47

alright..

Excelchat Expert
23/03/2018 - 01:48

The easiest way is to use the SORT button

Excelchat Expert
23/03/2018 - 01:48

but if this is not ok, you can also use conditional formatting for visual reference

Excelchat Expert
23/03/2018 - 01:49

But, if those two wont do, then, do you prefer a third column where you can have the ranking of each bank?

User
23/03/2018 - 01:50

Sir pls send me file

User
23/03/2018 - 01:51

About this question

Excelchat Expert
23/03/2018 - 01:51

Can you see my example on the right side?

Excelchat Expert
23/03/2018 - 01:51

Using the rank function is very easy

Excelchat Expert
23/03/2018 - 01:52

I'll put the formula on column C

Excelchat Expert
23/03/2018 - 01:53

Did you see it?

User
23/03/2018 - 01:53

No sir

User
23/03/2018 - 01:53

This is not right

Excelchat Expert
23/03/2018 - 01:53

Huh?

Excelchat Expert
23/03/2018 - 01:53

What do you mean "no"?

Excelchat Expert
23/03/2018 - 01:53

can you elaborate?

Excelchat Expert
23/03/2018 - 01:54

Please tell me your expected output

User
23/03/2018 - 01:54

I want to show revenue in C column

User
23/03/2018 - 01:54

Not rank

User
23/03/2018 - 01:56

But top to bottom

User
23/03/2018 - 01:56

And there are show bank name

Excelchat Expert
23/03/2018 - 01:56

Can you please give some examples?

User
23/03/2018 - 01:57

Bank name

Excelchat Expert
23/03/2018 - 01:58

alright, im trying to check it again

Excelchat Expert
23/03/2018 - 01:58

hang on for aa while

Excelchat Expert
23/03/2018 - 02:00

alright, try this

Excelchat Expert
23/03/2018 - 02:00

please extend the session a little bit

Excelchat Expert
23/03/2018 - 02:02

Please check out column D

Excelchat Expert
23/03/2018 - 02:02

Is that your desired output?

Excelchat Expert
23/03/2018 - 02:03

each bank has been arrange according to its revenue

Excelchat Expert
23/03/2018 - 02:03

Top most is the one with the highest revenue

Excelchat Expert
23/03/2018 - 02:03

If that is ok, I'll be glad to explain the formula to you

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*